If an SQL WHERE clause equals a certain value, show image.

[hambil]

Originally Posted by acidburn0520

Thanks Hambil, would you mind explaining the code for me? I've never used CASE statements.

Well, it's pretty straight foward. All I did was add the case statement to your original query:

SELECT * FROM stats_new WHERE is_pot = '1' OR is_sr = '1' ORDER BY RAND() LIMIT 1

SELECT *, CASE WHEN is_pot = '1' THEN 'image_pot' ELSE 'image_sr' END AS clan_image FROM stats_new WHERE is_pot = '1' OR is_sr = '1' ORDER BY RAND() LIMIT 1

If I fill this in with actual values and turn it into php code it might look like this:

PHP Code:

$clan_result = $db->query_first("
    SELECT *, 
    CASE WHEN is_pot = '1' THEN '" . DIR . "/images/clan/pot.jpg
    ELSE '" . DIR . "/images/clan/sr.jpg' AS clan_image 
    FROM " . TABLE_PREFIX . "stats_new
    WHERE is_pot = '1' OR is_sr = '1'
    ORDER BY RAND() LIMIT 1
");

echo "<img src='" . $clan_result['clan_image'] . "' border = '0'/>";