From: Tom Worster (fsbthefsb.org)
Date: Mon Apr 26 2010 - 19:35:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

On 4/26/10 7:36 PM, "Gary" <gpaulpaulgdesigns.com> wrote:

> I cant seem to get this working.
>
> $query="SELECT im.image_id, im.caption, im.where_taken, im.description,
> im.image_file, im.submitted, kw.fox, kw.wolves, kw.wildlife, kw.american,
> kw.scenic, kw.birds, kw.africa, kw.eagles, kw.hunter" .
> "FROM *images AS im"."JOIN keywords AS kw USING (image_id)" .

looks like there's no space between 'im' and 'JOIN' in the line above

> "WHERE ky.image_id = im.image_id";

try: print($query);

>
> Gets me this error message.
>
> 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 'keywords AS kw
> USING (image_id)WHERE ky.image_id = im.image_id' at line 1
>
> Anyone see where I am going wrong?
>
> Thank you.
>
> Gary
>
>
>
> __________ Information from ESET Smart Security, version of virus signature
> database 5063 (20100426) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]