Re: [PHP] Update statement sent by PHP to MySQL

2001-05-11 Thread Johannes Janson
Hi, > update $T1 set caption = $caption where name = $name put single quotes aroud the variables: caption='$caption'. You can do this aswell: $result = mysql_query("UPDATE $T1 SET caption='$caption WHERE name='$name'", $DB) or die(mysql_error()); if (! $result) { send the haeder... } hope it

[PHP] Update statement sent by PHP to MySQL

2001-05-11 Thread Andreas Pucko
Hi there, I am trying to update a row in my MySQL database (I am an newbie) It does not work, but the DB does not return an error. Is there an error in the syntax?? // Create the user record //-- -