Display icon if database value exeed some limit

[ghjk]

My php application i want to display a icon when it exeed some value. Eg: I have rainfall values in my database and if some value exeed the given higher limit the icon sholud display on my web page. How can i do that?

[Markus]

[php]
if($_waterfall_measurement > 200)
{
echo "<img src='exceeded.jpg' />";
}
else
{
echo "<img src='green.jpg' />";
}
[/php]

Just use an if statement :)
If the measurement is greater than 'whatever', show relevant image.

Regards

[ghjk]

[php]
if($_waterfall_measurement > 200)
{
echo "<img src='exceeded.jpg' />";
}
else
{
echo "<img src='green.jpg' />";
}
[/php]

Just use an if statement :)
If the measurement is greater than 'whatever', show relevant image.

Regards

This is what i have done. I want to get the value which exceed threshold value. how can i do that?[PHP]$qq = mysql_query("SELECT Rainfall_ID,Station_ID,Rainfall FROM rainfall ORDER BY Rainfall_ID");
while($row = mysql_fetch_array($qq)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
echo "$Station_ID".','."$Rainfall";

}

$qq = mysql_query("SELECT Station_ID,Threshold_Val FROM station ORDER BY Station_ID");
while($row = mysql_fetch_array($qq)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
echo "$Station_ID".','."$Threshold_Val";
}[/PHP]