mysql_fetch_array only showing 1 row when there's more

Question

I'm working on a app that requires a DB and I'm getting some problems, the code seems good but its only printing 1 row when I have 2, I have tested when I have it with 5 and I still get 1.

What I'm wanting to do is make an array of all the item_id's; I know I'm getting all fields at the moment but that was just for testing.

index.php:

<?php

mysql_connect('localhost', 'aaran', '*********');
mysql_select_db('aaran_aff_io');

$query = mysql_query("SELECT * FROM `items` WHERE `owner`='aaranmcguire'");
$results = mysql_fetch_array($query);

echo '<pre>';
print_r($results);

?>

DB:

SQL DB

DB Structure:

CREATE TABLE `items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `name` varchar(55) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `thumbnail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `owner` varchar(55) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Amazing how many people can read an answer written here on SO, but can't read the manual — Mark Baker
– Mark Baker, Commented Jan 10, 2012 at 21:02
@MarkBaker i did, i was trying the print_r at first so it was skipping results, my bad i guess.. — Aaran McGuire
– Aaran McGuire, Commented Jan 10, 2012 at 21:10

webbiedave · Accepted Answer · 2012-01-10 21:00:04Z

11

mysql_fetch_array only returns one row at a time. If you want all the rows placed into an array, you can iterate over the result set:

$query = mysql_query("SELECT * FROM `items` WHERE `owner`='aaranmcguire'");
$rows = array();
while ($row = mysql_fetch_array($query)) {
    $rows[] = $row;
}

echo '<pre>';
print_r($rows);

answered Jan 10, 2012 at 21:00

webbiedave

49k8 gold badges92 silver badges104 bronze badges

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

1 Comment

Aaran McGuire Over a year ago

thanks!... i was going something like this before but i was having problems because i was doing a separate print_r... link i will accept it as a answer when it allows me.

gen_Eric · Accepted Answer · 2012-01-10 21:00:32Z

1

Have a look at the manual for mysql_fetch_array. It returns the next row when it's called.

while ($row = mysql_fetch_array($result)) {
    print_r($row);
}

answered Jan 10, 2012 at 21:00

gen_Eric

228k42 gold badges304 silver badges343 bronze badges

Comments

Treffynnon · Accepted Answer · 2012-01-10 21:00:56Z

0

mysql_fetch_array() only returns one row at a time so you must use a while loop to iterate over all the rows.

while($row = mysql_fetch_array($query)) {
    echo '<pre>';
    print_r($row);
}

answered Jan 10, 2012 at 21:00

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

Collectives™ on Stack Overflow

mysql_fetch_array only showing 1 row when there's more

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related