Re: Returing multiple rows based on 2 criteria

[Barry Galbraith]

You get them here

// Retrieve Order Items
$sql = mysql_query("SELECT * FROM `order_line` WHERE `orderID` = ".$row['orderID']);
$orderItems = mysql_fetch_array($sql);

but don't retrieve orderItems into anything.

Also, you should NOT use SELECT * but SELECT column1, column2.... It's more efficient, and you know what field names you're going to get.

Good luck,
Barry.