Displaying records - PHP/MYSQL

[seorocks]

Hiya,

I need to write a script in php which checks if the value inserted in the database is higher or lower than a specific number and if the value is higher, it would display a certain statement and if its lower it display another. I am trying to use the script to display 20 figures for each subject and comparing it to the performance of previous month.

thanks,
Claire

[linkstraffic]

try something like that:

$q=mysql_query("SELECT (value > yourvalue) as result FROM yourtable");

while($ql=mysql_fetch_assoc($q))
{
  if($ql['result'])
echo 'sthg';
else echo 'sthgelse';

}