Database array only returns one row

Question

I am sorry for my lazy title. I hope that a moderator could improve it so the database won't get infected.

I got the following code (forum.php);

<?php

$res = $db->query('
  SELECT *
  FROM forums_categories
  ORDER BY category_id
');

while ($row = $db->fetch_array($res)) {
  $categories = array(
    'ID'   => $row['category_id'],
    'NAME' => $row['category_name']
  );

  echo '<pre>';
  print_r($categories);
  echo '</pre>';
}

And I got the following database structure;

|---------------|-------------------|
|  category_id  |  category_name    |
|---------------|-------------------|
|  1            | Example 1         |
|  2            | Example 2         |
|  3            | Example 3         |
|  4            | Example 4         |
|  5            | Example 5         |
|  6            | Example 6         |
|---------------|-------------------|

But my array only returns 1 value:

Array
(
    [ID] => 1
    [NAME] => Example 1
)

Oh and if somebody likes to know how my $db->fetch_array looks like:

<?php

function fetch_array($result)
{
return mysql_fetch_assoc($result);
}

How can I return all rows in my array? Thank you for reading and thank you for replying!

Just a reminder: Try not to use SELECT * - Reason: stackoverflow.com/questions/321299/… — Musterknabe
– Musterknabe, Commented Oct 8, 2013 at 15:38

Amal · Accepted Answer · 2013-10-08 17:34:36Z

3

You're overwriting the previous value of $categories on each iteration

$categories[] = array(
    'ID'   => $row['category_id'],
    'NAME' => $row['category_name']
  );

You might also want to initialize an empty array

$categories = array();

before your loop to avoid warnings.

edited Oct 8, 2013 at 17:34

Amal

76.8k18 gold badges133 silver badges154 bronze badges

answered Oct 8, 2013 at 15:22

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

2 Comments

Elon Than Over a year ago

We're declaring variables not only to prevent warnings, because warning is not problem. It's only telling us that we have problem.

user2781991 Over a year ago

Thank you for your information. It still does return one row but I get the feeling I am close.

Collectives™ on Stack Overflow

Database array only returns one row

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related