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:
$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);
($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.