Jump to content

Archived

This topic is now archived and is closed to further replies.

apocra

weird selection problem

Recommended Posts

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.