MySQL results issue in php array

Question

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; 
}

Please, don't use 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. — John Conde
– John Conde, Commented Jan 18, 2013 at 2:17

John Conde · Accepted Answer · 2013-01-18 02:17:09Z

3

Use while not if

while ($row = $result->fetch()) {
  $groups[] = $row; 
}

answered Jan 18, 2013 at 2:17

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Craig Taub · Accepted Answer · 2013-01-18 02:17:43Z

2

The code you have there does not iterate over the result set. Try this instead.

while ($row = $result->fetch()) { 
$groups[] = $row;
}

answered Jan 18, 2013 at 2:17

Craig Taub

4,1891 gold badge21 silver badges25 bronze badges

Comments

Francisco Presencia · Accepted Answer · 2013-01-18 02:26:47Z

0

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

  }

edited Jan 18, 2013 at 2:26

answered Jan 18, 2013 at 2:18

Francisco Presencia

8,8757 gold badges50 silver badges96 bronze badges

Collectives™ on Stack Overflow

MySQL results issue in php array

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related