Update ONLY ONE row WHERE user_id = 'testID' // user_id=testID in a lot of rows!

[nightkarnation]

Hey Guys,

A very noob question...Here it goes:

 

I want to update the field user_id on my database table, there a lot of rows that the user_id is the same... "testID", I just want to update only ONCE.

 

mysql_query("UPDATE `users` SET status = '$StatusCheck' WHERE user_id = 'testID'"); 

 

Right now it's updating ALL the rows that have the user_id "testID". I just want to update only one.

 

Any ideas?

Thanks in advance!

Cheers!

[Pikachu2000]

The query string should end with LIMIT 1

[nightkarnation]

Awesome, thanks Pikachu!

 

Cheers mate!