MySql Update Run Once only

[four4swords]

hi,

 

I have this problem here.. Where i want to update some info .. but only for ONE record..

 

Let's say i have a table like this..

 

Item    |  Type  | Stock

_{Apple  | Food    | 1}

_{Orange | Food    | 1}

_{Cat      |Animal  | 1}

_{Apple  | Food    | 1}

_{Orange | Food    | 1}

_{Cat      |Animal  | 1}

 

And I want just one row with the item CAT to decrease it's stock to zero..

 

mysql_query("UPDATE itemsSET Stock = '0' WHERE Type = 'Animal   '") or die(mysql_error());

 

That bit of code there.. will change ALL my "ANIMAL" types to a stock of ZERO..

 

What can i do so that only ONE row is changed to ZERO?

 

Thanks!

[peranha]

You would have to insert an ID field, and have it referenced in the query instead of the type.

 

[four4swords]

ouch.. lol I didn't add in an ID field!

 

Is there any other way to do it?!

[fenway]

ouch.. lol I didn't add in an ID field!

 

Is there any other way to do it?!

So add one.

[aschk]

ALTER TABLE <table name here> ADD COLUMN id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY BEFORE `Item`