Not displayin data

[Anon]

If I dont have a image in a database how would i write it so if the image wasnt there it would show nothing or anaoher image. Here is my code so far
$sql= "SELECT * FROM news ORDER BY newsid";
$result =@($sql, $connection) or die("Couldnt excecute query.");
while ($row = mysql_fetch_array($result)) {
$title =$row['title'];
$image =$row['image'];
$news =$row['news'];
$date =$row['date'];

$display_news .="<table border=0 cellpadding=0 cellspacing=0 align=center width='372'>
<tr>
<td class='newstitle' colspan='2'> $title </td>
<td width='118'><img src='images/$image' width='15' height='1'></td>
</tr>
<tr>
<td><img src='images/$transparent' width='30' height='1'>$news</td>
</tr>
<tr>
<td class='date' align=right>$date</td>
</tr>

  </table >";

}

[techek]

Hiya! It's fairly easy. What you have to use is a control-structure (don't let me fool you, statements are just made of commands like IF, ELSE and such)

Adopt this example and see what you get out of it :

<?php
if ($image) {
echo "<td width='118'><img src='images/$image'><br></td>\n";
} else {
echo "<td width='118'><img src='images/default.gif' width='15' height='1'><br></td>\n";
}
?>

Note that I've stripped the height and width-attribs when you're going to show a picture. Or else it would have become VERY low (height=1 ?)

Hint : Go have a look at IF, ELSE and other commands at http://www.php.net/manual/en/control-structures.php

[Anon]

thank you