SV: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

2004-08-06 Thread Henrik Hornemann
Hi, Mysql_fetch_row() fetches an enumerated array, so it should be: If ($row[1] 100) while ($row = @ mysql_fetch_row($result)) { foreach($row as $data) if ({sum(number_o_beans)} (100)) if($row['total_number_of_beans']) 100) print \n\ttd {$data} /td; print \n/tr; }

[PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

2004-08-05 Thread Grant Listhandle
In the database beans i have a table bags_o_beans where each row represents a single bag, and columns named bean_type and number_o_beans My teenage son is having several thousand hungry friends over in half an hour, and I'm stuck making the bean dip... I'm going to need 1 million beans of a

Re: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

2004-08-05 Thread Justin Patrin
On Thu, 5 Aug 2004 17:26:05 -0500, Grant Listhandle [EMAIL PROTECTED] wrote: In the database beans i have a table bags_o_beans where each row represents a single bag, and columns named bean_type and number_o_beans My teenage son is having several thousand hungry friends over in half an hour,

Re: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

2004-08-05 Thread John Holmes
Grant Listhandle wrote: In the database beans i have a table bags_o_beans where each row represents a single bag, and columns named bean_type and number_o_beans My teenage son is having several thousand hungry friends over in half an hour, and I'm stuck making the bean dip... I'm going to need 1