When using the client library with 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? With kind regards, Gijs --------------------------------------------------------------------- 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