Can anybody tell me why not all the results for MySQL aren't ending up in the array?
$result = mysql_query("select * from groups order by id desc");
if ($row = $result->fetch()) {
$groups[] = $row;
}
3 Answers
Use while not if
while ($row = $result->fetch()) {
$groups[] = $row;
}
Comments
The code you have there does not iterate over the result set. Try this instead.
while ($row = $result->fetch()) {
$groups[] = $row;
}
Comments
Because fetch only fetches a row as explained in the php manual:
Fetches the next row from a result set
I'd like to suggest changing your mysql_ code for PDO
$db = new PDO("..."); // Creates the PDO object. Put the right arguments for your connection.
$statement = $db->prepare("SELECT * FROM groups ORDER BY id DESC");
$statement->execute();
while ($groups = $statement->fetch())
{
// Do whatever you want to do
}
answered Jan 18, 2013 at 2:18
Francisco Presencia
8,8757 gold badges50 silver badges96 bronze badges
mysql_*functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.