Hi guys,

Why is this valid syntax in the mysql command line client:

select t1.id from akl_lng_shows_link_table as t1, akl_afr_shows as t2, akl_shows_genres_afr as t3 where t1.afr_id = t2.id and t2.genre_id = t3.id order by t3.name asc

retunrs the correct result, but in PHP 4.3.4 it returns

[Polarserver] ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''
?

It seems that PHP does not support alias-selecting in MySQL queries?

Any help appreciated!

Thanks...

By the error it sounds more like you have an extra quote somewhere or there is no query being sent to the server - can you copy and paste the php code.