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
