Posted by AnrDaemon on 11/08/07 09:14

Greetings, Steve.
In reply to Your message dated Wednesday, November 7, 2007, 20:19:23,


> "Einstein30000" <dominic_ernst@web.de> wrote in message
> news:1194453026.587359.180320@19g2000hsx.googlegroups.com...
>> Hi,
>>
>> in one of my php-scripts is the following query (with an already open
>> db-connection):
>>
>> $q = "INSERT INTO main (name, img, descr, from, size, format, cat,
>> host, link, date) VALUES ('$name', '$img', '$descr', '$user', '$size',
>> '$format', '$cat', '$host', '$link', '$date')" or die(mysql_error());
>>
>> And when the query gets executed i get back the following error:
>>
>> 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 'from, size, format, cat, host, link, date) VALUES ('bla', '-',
>> 'keine', 'Holgi',' at line 1
>>
>> Whats wrong here?!

> your sql statement is F.U.C.K.E.D !!!

Agree but not in the way You think about.

> hmmmm...perhaps you'll now see the
> value in FORMATTING your queries where a HUMAN BEING can read it. makes it
> easier to debug. :)

Actually, problem is proper quoting, not the format or anything else.

> $sql = "
> INSERT INTO main
> (
> `name` ,
> `img` ,
> `descr` ,
> `from` ,
> `size` ,
> `format` ,
> `cat` ,
> `host` ,
> `link` ,
> `date`
> )

That way. All should work now.


--
Sincerely Yours, AnrDaemon <anrdaemon@freemail.ru>

[Back to original message]