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

Check your mysqld.log (if you have it turned on) so you can see what php actually submitted to mysql...The log captures everything mysql receives, so in a busy environment grows quickly...but it is a great way of finding out discrepancies such as the ones you are describing... Luis --- John Guynn <John.Guynn@telescan.com> wrote: > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-db-unsubscribe@lists.php.net > For additional commands, e-mail: > php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/