[SOLVED] sql update statement not working

[geroid]

Can you help with this update statement. I get the following error message:

 

Could not insert data because 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 ')' at line 1

 

The code I'm using is:

 

$insert = mysql_query("update $table set event_name='" .$_SESSION['evname']. "', venue_name='".$_SESSION['venuename']."', streetaddress1='".$_SESSION['addr1']."', town='".$_SESSION['town']."', county='".$_SESSION['county']."', event_description='".$_SESSION['content']."', event_date='".$_SESSION['fulldate']."', event_time='".$_SESSION['time']."' where event_num = '".$_SESSION['editwhatrecord']."')")  or die("Could not insert data because ".mysql_error());

[Maq]

You have an extra closing parenthesis.

[geroid]

Sorry Maq

I don't understand. Could you be more specific?

[revraz]

".$_SESSION['editwhatrecord']."')") <-----

[mattal999]

Your query should be:

 

$insert = mysql_query("update $table set event_name='" .$_SESSION['evname']. "', venue_name='".$_SESSION['venuename']."', streetaddress1='".$_SESSION['addr1']."', town='".$_SESSION['town']."', county='".$_SESSION['county']."', event_description='".$_SESSION['content']."', event_date='".$_SESSION['fulldate']."', event_time='".$_SESSION['time']."' where event_num = '".$_SESSION['editwhatrecord']."'")  or die("Could not insert data because ".mysql_error());

 

You had an extra ) in there after 'where event_num..."'

[Maq]

EDIT: There you go.  --^

[Cosizzle]

it means that you have one to many ) somewhere... do you get an error saying line number?  Maq's code will show errors

[PFMaBiSmAd]

If you form your queries in a variable and then put that variable into the mysql_query statement, it will keep the syntax of the query separate from the syntax of the code running the query and it will be easier to see problems like that.

[geroid]

Thanks everyone that worked great. Everything is fine now