[PHP] Re: [php] & [mysql] select and subselect

On Mon, 16 Nov 2009 14:21:41 -0800, Allen McCabe wrote: > I have an order table that keeps track of the order_id, the date, the > status, etc. I also have an order_lineitem table that is the contents of the > order. This has a one-to-many structure (without foreign keys because it is > mysql).

[PHP] Re: [php] & [mysql] select and subselect

Allen McCabe wrote: > I have a page on my site where I can optionaly filter by certain fields > (order by filesize or file category), but I am implementing a shopping > cart type of idea where users can submit an order. > > As administrators, my coworkers and I need to be able to filter orders by

[PHP] Re:[PHP] MySQL Select

think this is what you want $i = 0; $result = mysql_query("SELECT jazz FROM funk WHERE foo='bar'") while($music = mysql_fetch_array($result)) { $funk_music[$i] = $music[0]; $I++; } ok...sorry to ask a stupid question but $result = mysql_query("SELECT jazz FROM funk WHERE foo='