Thanks everybody, and Sam, that makes sense WRT the multiple words causing
troubles.
On Wed, 1 Aug 2001 12:54:01 -0400, Sam Masiello wrote:
>
>You will need to put single quotes around your variables in your SQL
>statement. Like this:
>
>$sql = "UPDATE TABLE seminar SET
>title='$title',speaker='$speaker',event_date='$tdate',time='$time',bldg='$bu
>ilding'
>,rm='$room' WHERE id='$id'";
>
>Without the quotes, SQL doesn't know that Something Amazing is supposed to
>go together in the same string.
>
>HTH
>
>Sam Masiello
>Software Quality Assurance Engineer
>Synacor
>(716) 853-1362 x289
>[EMAIL PROTECTED]
>
> -----Original Message-----
>From: Chris Worth [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 01, 2001 12:36 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP] SQL syntax error in PHP script. dunno what's wrong
>
>
>
>hey gang.
>
>here is my sql statement from my php script.
>
>$sql = "UPDATE TABLE seminar SET
>title=$title,speaker=$speaker,event_date=$tdate,time=$time,bldg=$building
>,rm=$room WHERE id=$id";
>
>
>it appears just like that in my code.
>
>here is the $sql string echoed to the screen to verify the variables.
>
>
>UPDATE TABLE seminar SET title=Something amazing,speaker=Mr.
>Black,event_date=2001-08-05,time=11:00:am,bldg=BCC ,rm=201 WHERE id=48
>
>all of the variable are valid.
>
>here is my error.
>
>1064: You have an error in your SQL syntax near 'TABLE seminar SET
>title=Something
>amazing,speaker=Mr.
>Black,event_date=2001-08' at line 1
>
>I'm baffled.
>
>
>and I couldn't find error 1064 in the mysql manual.pdf either.
>
>any ideas. I know this is going to turn out to be something silly.
>
>thanks,
>
>chris
>
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
