3 items in table, mysql_fetch_array shows only 1
Posted: Fri Jun 03, 2011 10:38 am
here is a BASIC php mysql query running in a function:
Here is the table, the first field is the cid:
My var_dump shows only the values of the 1st row.
The other 2 rows that follow the same condition are not appearing in the array.
Any clue as to why this limitation would be happening?
It's oh so frustrating.
Code: Select all
$select = mysql_query("SELECT price, quantity FROM cart_items WHERE (cid = '1')");
$row = mysql_fetch_array($select) or die (mysql_error());
var_dump($row);Code: Select all
1 59530N34022 94 2
1 15123N21999 83 2
1 13723N48311 110 2The other 2 rows that follow the same condition are not appearing in the array.
Any clue as to why this limitation would be happening?
It's oh so frustrating.