php help

[mrdeleigh]

I need a small bit of php which will achive this:

check if the value in the column "X" of the "Y"
table is empty (and show AAA.jpg) and if not show BBB.jpg

can someone help?

mrdeleigh

[ataria]

[code]<?php
$check = mysql_num_rows(mysql_query("SELECT `x` FROM `y`"));
if ($check == '0') {
echo "<img src=/AAA.jpg>";
}
else {
echo "<img src=/BBB.jpg>";
}
?>
[/code]

[mrdeleigh]

thanks I'll try that