MySQL Update help needed
| From: | Chris Payne | Date: | Mon, 21 Jan 2002 05:17:34 +0000 |
| Subject: | MySQL Update help needed | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16019@lists.php.net to get a copy of this message | ||
Hi there,
Can anyone see what is wrong with this query? I am trying to update some fields, if I do an echo
everything looks good but it doesn't update the fields in the DB - am I missing something
obvious here?
Thanks for your help
Chris
www.planetoxygene.com
$mysql_query ("UPDATE search6 SET email = '$email',description =
'$comments',category = '$category',url = '$url',type =
'$type',country = '$country',rating = '$rating',fname =
'$fname',state = '$state',region = '$region',city = '$city'
WHERE id = '$id'");