Re: MySQL Update help needed

did test to see if $id was actual the value you were expecting? is $id an auto increment field? Chris Payne <chris@planetoxygene.com> wrote in message 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'");