did test to see if $id was actual the value you were expecting? is $id an
auto increment field?
Chris Payne <[EMAIL PROTECTED]> wrote in message
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
$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'");
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php