Re: sql problem
| From: | Sue Bailey | Date: | Thu, 10 Aug 2000 11:45:38 +0000 |
| Subject: | Re: sql problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-11122@lists.php.net to get a copy of this message | ||
You shouldn't have 'and' in the middle or the brackets, or table before
$table_all; like this:
$sql = "update $table_all set title='$title', link='$link' where
category='$category' ";
Sue
----- Original Message -----
From: Worawisut Pinyoyang <s0010684@kmitl.ac.th>
To: <php-general@lists.php.net>
Sent: Thursday, August 10, 2000 12:42 PM
Subject: [PHP] sql problem
>
> i have a problem about sql like this
>
> $sql = "update table $table_all set (title='$title') and
> (link='$link')
where category='$category' ";
> $query = mysql_query($sql);
>
>
> but query doesn't execute. (Table doesn't update)
> how can i do ?
>
> thanks very much
>
> W.Pinyoyang
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net