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 000c01c1a23a$ef779900$0200a8c0@chris">news:000c01c1a23a$ef779900$0200a8c0@chris... 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'"); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
