Re: SQL syntax error in PHP script. dunno what's wrong
| From: | Matt Greer | Date: | Wed, 01 Aug 2001 16:44:49 +0000 |
| Subject: | Re: SQL syntax error in PHP script. dunno what's wrong | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-60696@lists.php.net to get a copy of this message | ||
on 8/1/01 11:35 AM, Chris Worth at caw@bcc.louisville.edu 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