Re: [PHP] SQL syntax error in PHP script. dunno what's wrong

[Matt Greer]

on 8/1/01 11:35 AM, Chris Worth at [EMAIL PROTECTED] wrote:

> 
> 
> 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";
>

strings in a mysql query need to be quoted. So change it to

$sql = "UPDATE TABLE seminar SET title='$title',speaker='$speaker',...";

Matt


-- 
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]