Re: [PHP-DB] What is going on?!? PHP-MySQL query weirness From: Adv. Systems Design (asd_2000 <email protected>)
Date: 11/22/00

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 <email protected>> 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 <email protected>
> For additional commands, e-mail:
> php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
>

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/ 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>