Re: UPDATE - MySQL having some trouble
| From: | Greg Donald | Date: | Wed, 23 Jan 2002 15:57:44 +0000 |
| Subject: | Re: UPDATE - MySQL having some trouble | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-81702@lists.php.net to get a copy of this message | ||
> I can't the UPDATE command in MySQL to work properly. Here is my
> query....
>
> $query = "update table set lastname=$lastname, firstname=$firstname
> where username=$username";
>
> Anything wrong with my syntax here?
$query = "
update table set
lastname = '$lastname',
firstname = '$firstname'
where
username = '$username'
";
--
Greg Donald
greg@ascendantmedia.com