What is going on?!? PHP-MySQL query weirness

From: Date: Wed, 22 Nov 2000 16:41:29 +0000
Subject: What is going on?!? PHP-MySQL query weirness
Groups: php.db 
Request: Send a blank email to php-db+get-4662@lists.php.net to get a copy of this message
I have the following code: $result = mysql_query("SELECT Date FROM $dbname ORDER BY Date"); ($dbname is set to neon) $row = mysql_fetch_array($result); Pretty standard stuff right. When the code executes $row has 2 values in the array. The problem is when I go to the mysql command line and execute SELECT Date FROM neon ORDER BY Date; I get 49 rows in set as a result which is what I expect. I've never had the PHP code return less than the correct number of items. Also the values in $row are 1995-09-26 (the first date) and BLANK (nothing echos to the screen in $row[1]). Any ideas? John Guynn

« previous php.db (#4662) next »