Hi, Mysql_fetch_row() fetches an enumerated array, so it should be: If ($row[1] > 1000000) > > while ($row = @ mysql_fetch_row($result)) { foreach($row as $data) if > ({sum(number_o_beans)} > (1000000)) if($row['total_number_of_beans']) > 1000000) > print "\n\t<td> {$data} </td>"; > print "\n</tr>"; > } > > Thanks ahead of time for your thoughts and recipes :) Grant > > -- > PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: > http://www.php.net/unsub.php > > !DSPAM:4112b26a148642019194572! > > -- DB_DataObject_FormBuilder - The database at your fingertips http://pear.php.net/package/DB_DataObject_FormBuilder paperCrane --Justin Patrin-- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php