Problem with Query using PHP

[brokenflea]

i'm trying to update a mysql table using this query,

$sql4 = mysql_query("UPDATE subp SET " .
"agm='$agm', " .
"coach='$coach', " .
"empid='$empid', " .
"name='$empname', " .
"date='$today', " .
"nb='$htmlnb', " .
"bb='$htmlbb', " .
"hsio='$htmlhsio', " .
"WHERE date='$today' AND empid='$empid'");

and everytime the query parses, i get this error:

Error performing query :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 'WHERE date='2004-08-11' AND empid='11112'' at line 1

i'm stumped at this one.. any help would be greatly appreciated.
TIA

[Lats]

Try this...

$sql4 = mysql_query("UPDATE subp SET 
agm='$agm',  
coach='$coach',
empid='$empid', 
name='$empname', 
date='$today', 
nb='$htmlnb', 
bb='$htmlbb', 
hsio='$htmlhsio'
WHERE date='$today' AND empid='$empid'"); 

[brokenflea]

thanks for the quick reply, but still gives me the same error

[brokenflea]

actually, i just got it to work, thanks for your help, it was a syntax error on my end, but i do appreciate all your help. thank you so much!

[Lats]

Good to hear that it's working for you