Updating existing record

[edpudol]

Hello fellows!

Could you please help me, I need a script that I use to update my existing single record.

mysql_query("UPDATE counter SET field = '$var' WHERE countrycode ='$code'")

my problem with this code is that all record meet the criteria is automatically updated.

What I want is to update the first record only not all record with thesame country code for example.

Thanks for the help

[Shrike]

Use the WHERE clause to limit the update to one record.

[Weedpacket]

And consider modifying your database structure so that your criteria can say exactly which record you want updated.

[edpudol]

hi Shrike

Could you please give me a sample. Well I think my database was design good enough but there is a time that I really nead to this, updating one record only with the same category and I use category to search all the records in my dbase.

[Shrike]

"UPDATE counter SET field = '$var' WHERE countrycode ='$code' AND someuniquefield = '".$someuniquevalue."'";