What's wrong?????

[Anon]

hi..

I have an error with the following script. Elements from a form a posted to the following script...(below is a partition):

=================
$query = "INSERT INTO $airlineselect (id,departure,destination,deptime,arvtime,aircraft_id,avail,comments,monday,tuesday,wednesday,thursday,friday,saturday,sunday) VALUES ('$id','$departure','$destination','$deptime','$arvtime','$aircraft_id','$avail','$comments','$monday','$tuesday,'$wednesday','$thursday','$friday','$saturday','$sunday')";

mysql_query($query) or

die (mysql_error());

and when I submit a form, I get:

"You have an error in your SQL syntax near '1','1','1','1','1')' at line 1"

What the hell does this mean? and what's wrong with the script?

Thanks
ben

[[deleted]]

No closing quote after $tuesday.

[Anon]

I spent HOURS AND HOURS overlooking that script that you come along and within seconds...and notice that "'" is missing.

ach well, that's why you where born, and that's why I came here!

Thanks ever so much (big releif over here!)
Ben

[amcgrath]

This one begs for a joke, and it's Friday, and well, I can't resist:

Vincent, how many times have I told you? Stop having family members post glowing comments about you!!! Jeesh!!!

[[deleted]]

I'm sorry Allen, I told them to stop it, but I guess I'm just so good that they can't resist...

... and so modest too. :-)

[Anon]

it has to be said, that one of the best things about this forum is Vincents amusing posts to newbies who fail to ever search :-)

No, we're not related, (but you can give me that £10 l8r) :-)

[amcgrath]

haha, i'm still laughing about my "restraining order" joke on that other thread... I crack myself up.

[[deleted]]

restraining order? whatdidImiss? 🙂