MySQL Forums
Forum List  »  PHP

Re: where clause is ambiguous
Posted by: Peter Brawley
Date: March 18, 2008 02:57PM

>it's supposed to return all listings whose "state" column
>matches the "state" value

Where a column named state contains the string 'state', or the string contained in $state?

In any case,

order by 'state'

makes no sense, since 'state' is a constant.

PB

Options: ReplyQuote


Subject
Written By
Posted
March 03, 2008 01:05PM
Re: where clause is ambiguous
March 18, 2008 02:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.