I am a bit stuck with what is probably very simple.
I have a script to query a mysql property database, I need to know how to use conditions within the record set. Here is my code:
Code: Select all
<?php
$query = ("SELECT * FROM property ORDER BY RAND() LIMIT 10")
or die(mysql_error());
$result = mysql_query($query,$conn);
while($row = mysql_fetch_array($result)) {
?>
<div class="res-holder">
<div class="res-img-border">
<div class="res-img"><a href="/propertydetails.php?PID=<?php echo$row['PID'];?>"><img src="<?php echo $row['MainImg'] ; ?>" width="130" height="90" border="0"/></a></div>
</div>
<div class="res-price">£ <?php echo $row['Price']; ?></div>
<div class="res-type"><?php echo $row['Beds']; ?> Bed <?php echo $row['Type']; ?></div>
<div class="res-loc"><?php echo $row['L3Name']; ?></div>
</div><!-- res-holder END -->
<?php } ?>Code: Select all
<div class="res-loc"> if { $row['L3Name'] = null } echo $row['L2Name'] else { echo ['L3Name'] } </div>
Any help would be very much appreciated
thanks
Baz