MySQL if / else语句依赖MySQL结果[关闭]

Question

I need some help I am a bit stuck:

I would like it so that IF a row in a table equals YES then it displays a certain image, however IF that row in the table equals NO then it displays another image.

Do you have any ideas?

if($fetch["g1"] == 1) $buffer .= 'Group 1, '; 
if($fetch["g2"] == 1) $buffer .= 'Group 2, '; 
if($fetch["g3"] == 1) $buffer .= 'Group 3, '; 

echo substr($buffer,0,-2).' ';

Answer 1

Your question is pretty vague, but this shows how to fetch a row and conditionally choose the source for an <img> tag:

# fetch the row
$row = mysql_fetch_array(mysql_query("SELECT * FROM table WHERE foo=$bar"));

# determine image to show
$img = $row['field'] == 'YES' ? 'img-one.gif' : 'img-two.gif';

# output
echo "<img src=\"$img\" />";