|
|
Posted by lawrence k on 11/08/07 04:33
On Nov 7, 12:19 pm, "Steve" <no....@example.com> wrote:
> "Einstein30000" <dominic_er...@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 !!! hmmmm...perhaps you'll now see the
> value in FORMATTING your queries where a HUMAN BEING can read it. makes it
> easier to debug. :)
Programmers will always disagree about how to style their code. Which
is better, camelCase or under_scored variable names? People get into
holy wars over this stuff. A great deal of energy is wasted on issues
that, in the end, are mere matters of taste.
Navigation:
[Reply to this message]
|