apocra
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by 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
weird selection problem
in MySQL Help
Posted