Yeah, I found the problem, It was adding a "order by lower(title)" in another class which I forgot about when I was trying to test the query.
so it works fine now. So yep, using, joines, case, order bys, lowers,inheritance in php/postgres all work fine. 1LT John W. Holmes wrote: >Double check that you have a.title, and not just title by itself. Two >tables must have a title column, so make sure you specify which one you >mean. > >---John Holmes... > >----- Original Message ----- >From: "Aaron" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, June 12, 2002 12:40 AM >Subject: [PHP] Postgres query problem > > > > >>I have a sql quer like this : " select a.title AS bugga, b.id AS asdf >>FROM tableone AS a FULL JOIN tabletwo AS b ON(a.title=b.filething)" >> >>anyway, thats a test query which is slightly smaller then the one I >>want. BUT when i use it from the command console in postgres, it works >>no problem >> >>but in php it complains about ambiguos column "title"...... so I dont >>know what I can do about it. >> >> >>-- >>PHP General Mailing List (http://www.php.net/) >>To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
