|
|
Posted by Kenoli on 02/09/07 14:38
On Feb 9, 2:54 am, "J.O. Aho" <u...@example.net> wrote:
> Captain Paralytic wrote:
> > On 9 Feb, 05:19, "Kenoli" <kenol...@gmail.com> wrote:
> >> On Feb 8, 12:57 pm, "Paul Lautman" <paul.laut...@btinternet.com>
> >> wrote:
>
> >>> Is person_id a string or a number?
> >> It's a number.
>
> > Then the reason that your query is failing is most likely that you
> > have put quotes arund the 5 and 6, making them into strings and are
> > trying to compare them with person_id which is a number.
>
> The single quotes around the values has no ill effect, there is something else
> that is wrong, and Kenoli should output mysql_error() to see what went wrong.
>
> --
>
> //Aho
I get the error:
MySQL Error: Column 'person_id' in where clause is ambiguous
--Kenoli
Navigation:
[Reply to this message]
|