Posted by Steve on 11/08/07 18:28

"The Natural Philosopher" <a@b.c> wrote in message
news:1194542959.6724.0@proxy00.news.clara.net...
> Steve wrote:
>> "lawrence k" <lkrubner@geocities.com> wrote in message
>> news:1194496438.926297.74650@o38g2000hse.googlegroups.com...
>>> 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.
>>
>> that's bullshit. i don't care what people prefer when they decide to
>> formalize their style of programming. what i get incensed about is when
>> no measure of formality is considered good practice. as for 'mere matters
>> of taste', you simply missed the boat on the subject at hand...NO
>> FORMATTING vs. ANY formatting.
> The trouble with standards is here are som nay to choose from..
>
>
>
> $query="select name, id from employees order by name";
>
> Nowt wrong with that is there?
>
> Now consider
>
> $query =sprintf( "select name, id, number, picture, phone, email from
> employees where id= (select employee_id date from sacked where name like
> %s%% order by sacked.date )",$badboys);
>
> and it starts to get messier..
> You don't slavishly follow rules..unless you are a jerk, or working for
> one.....

oh, so 'dont be a jerk'...is THAT how you make a point? ad-homonym all you'd
like. the rest of us set policy and are consistent about following it. draw
your messy grey lines where you will.

[Back to original message]