On Mon, Feb 24, 2003 at 10:19:01AM +0100, G. Hesen wrote: > When using the client library with php:
Have you also changed versions of PHP? > Earler(earler mysql version) mysqllib: > SELECT userfield.*,user.* FROM ..... > [1] => 123 > [userid] => 123 > > Now with MySQL 3.23.54 mysqllib: > > SELECT userfield.*,user.* FROM ..... > [1] => 123 > [userid] => > > Here you can see that mysql doesn't give the userid anymore if the userid's > are the key to join 2 tables. > > I corrected this with: > > SELECT userfield.*,user.*,user.userid as userid FROM ..... > [1] => 123 > [userid] => 123 > > Is this is a bug? Or a behaviour change? What does the query return if you run it from the MySQL command line client? Cheers! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Toronto, March 24-28, 2003 Visit http://mysql.com/training for more information --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
