Re: do table alias's work in PHP?

Since it works for you then it MUST be a version thing. How odd that it works from the command line. It would have been a pain to do an upgrade just to find out the problem didnt go away. I appreciate your taking the time to test it for me. Thanks again!!!! Johannes Janson wrote: > I'm not sure but couldn't it really be that this is > due to the MySQL version? PHP is just passing > a string which is then executed by MySQL. I think > I recall having no problems with aliases. I don't quite > remember which version it was but I think it was 3.23.*. > > > Now I am using a shareware version which, perhaps, is buggy: > > 3.22.24-shareware-debug > > Probably is a problem of the version... > I simply had to test it again. Here's very simple a script that worked fine. > > $sql = "SELECT a.id as ida, b.id as idb FROM alleuebungen a, > allevorlesungen b WHERE a.id=b.id"; > > $result = mysql_query($sql) or die(mysql_error()); > > while (list($ida, $idb) = mysql_fetch_array($result)){ > > echo "$ida, $idb<br>"; > } > > I'm using 3.23.36. > > hope it helps > Johannes > > -- > 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