SV: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute
| From: | Henrik Hornemann | Date: | Fri, 06 Aug 2004 08:07:14 +0000 |
| Subject: | SV: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35617@lists.php.net to get a copy of this message | ||
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