Re: Returing multiple rows based on 2 criteria

[chris d]

Thanks for the quick replies Barry,

Yeah, that code correctly retrieves the first record with orderID 100012, and correctly outputs item 100 which is "Eggs on a roll" but now i want to retrieve the next item in that table with an orderID of 100012 and display it, which is item 103 and so on and so forth.

The goal is to output a comma separated list of all items that belong to a particular orderID.

Im under the impression that when i use mysql_fetch_array that it only retrieves and stores one single record into whichever array variable i declare it to.

Thanks again!