SQL Syntax error???

starter911

Hello!
I seem to have an sql syntax error in my script, I just don't see what the problem is. Can somebody help me???

  $query = "UPDATE task1 SET ". 
       "employee_name = \"" . $formVars["employee_name"] . "\", " .
       "company = \"" . $formVars["company"] . "\", " .
       "priority = \"" . $formVars["priority"] . "\", " .
       "task = \"" . $formVars["task"] . "\", " .
       "WHERE task1_id = " .$edit;


  // Run the query on the customer table
  if (!(@ mysql_query ($query, $connection)))
     showerror();

Error message is:

Error 1064 : You have an error in your SQL syntax near 'WHERE task1_id = 1' at line 1

Thank you very much.
A.

LordShryku

It's the comma after $formVars["task"]

superwormy

Depending on the database, it could be your use of "double quotes" instead of 'single quotes'

starter911

Thanks a lot, I found it out myself. That silly little comma. I had an extra line there and deleted it. after that I forgot to take the comma away.
Thanks anyway, I'm glad it works now...
Cheers

starter911

Thanks a lot, I found it out myself. That silly little comma. I had an extra line there and deleted it. after that I forgot to take the comma away.
Thanks anyway, I'm glad it works now...
Cheers