Need help with an 'IF THEN' statement

[TheWart]

Hi all,

I have a database of plants (hehe, I know, but it is for my boss) and while some of the plants have their own individual pages which I link to off of the main database page (using php btw), some of them do not.

Unfortuantely, I do not know how to code the php so that only if there is a value for row 10 (symbol that I use to make url), to make it a hyperlink, but if the value of row 10 is null, not to make a link.

The relevant part of my code is shown below:

while ($tablerows = mysql_fetch_row($sql))
{

$symbol = $tablerows['10'];
$picture = $tablerows['9'];

echo("<tr><td><img src=../$picture><td><i><a href=http://www.cas.vanderbilt.edu/perl/bioview.pl?genspec=$symbol&action=View>$tablerows[1]</a></i></td><td>$tablerows[2]</td><td>$tablerows[3]</td><td>$tablerows[4]</td><td>$tablerows[5]</td><td>$tablerows[6]</td><td>$tablerows[7]</td><td>$tablerows[8]</td></tr> ");
}
echo "</table>";

Thanks a ton for any help....I also just want to say what a great help this site has been over the last number of weeks...everytime I have come with a question, no matter how noobish, someone helps within a day or so...you guys rock!

[bastien]

try something like :

...
if (!is_null($tablerows['10'])){
  $symbol = $tablerows['10'];
}else{
  $symbol = "";
}
$picture = $tablerows['9'];

if ($symbol != "") {
  echo("<tr><td><img src=../$picture><td><i><a href=http://www.cas.vanderbilt.edu/perl/bioview.pl?genspec=$symbol&action=View>$tablerows[1]</a></i></td><td>$tablerows[2]</td><td>$tablerows[3]</td><td>$tablerows[4]</td><td>$tablerows[5]</td><td>$tablerows[6]</td><td>$tablerows[7]</td><td>$tablerows[8]</td></tr> ");
}//end if

[TheWart]

Thanks a ton....I just added an 'else' statement after the second 'if' to display the results without $symbol, but not make them urls.

thanks again