Multiple Rows
Posted: Tue Aug 03, 2010 4:37 am
Hi all, I'm having some problems querying multiple rows in a table. I would massively appreciate it if someone could just take a quick look at my code and tell me where I've gone wrong.
Many thanks in advance
Dan
Code: Select all
$result = mysql_query("select filling_id from order_filling where order_id = 1");
while ($of = mysql_fetch_array($result))
{
$result = mysql_query("select * from filling where filling_id = $of[0]");
$filling = mysql_fetch_array($result);
$filling_string = $filling[name] . ", " . $filling_string;
}
Dan