weird selection problem

[apocra]

Hi all,

I've got this weird problem which I can't seem to get rid off. I bet it will be some minor glitch I keep failing to notice, I hope someone here can help me.

I've got a database with multiple records (2 in the test-db) which I want to print onscreen in a table. But before that I want to check the id of the records with the id in a textfile. To do this I try to get the id's in a array (test-db has id #1 and #45) and am using the following code:

[code]$pid = mysql_query("SELECT id FROM profiel ORDER BY id ASC LIMIT $num")
or die('Could not find data in database ' . mysql_error());

$pid2 = mysql_fetch_array ($pid, MYSQL_NUM);
[/code]

($num = the number of rows in the db and I've checked this, it's 2)

The array $pid2 only has one id in it and not the 2 that are in the database.

Help would be very much appreciated.

Cheers,
Apocra

[shoz]

mysql_fetch_array returns one row at a time.
[code]
$pid = mysql_query("SELECT id FROM profiel ORDER BY id ASC LIMIT $num")
or die('Could not find data in database ' . mysql_error());

while($pid2 = mysql_fetch_array ($pid, MYSQL_NUM))
{
    echo $pid2[0]."<br />\n";
}
[/code]
http://php.net/mysql_fetch_array

[apocra]

Thanks, that did the trick! I knew it would be some stupid oversight.