MYSQL PHP update data of each row

Question

I have this question which I'm thinking for some time.

I have a table like this shown using php code in browser

username  |  price  |  description | 

 a       |  aaa     |   pending | [yes] [no] 
 b       |  bbb     |   yes     | [yes] [no]
 a       |  ccc     |    no     | [yes] [no]

only username, price and description are from mysql database.

for the [yes] and [no] is the button post to the query of this. products is my table name

 [yes] = UPDATE products SET description='YES' WHERE description='PENDING'
 [no]  = UPDATE products SET description='NO' WHERE description='PENDING'

What can I do with my query? I want the yes and no button update only a single row, Can I use GROUP BY ? The query I used is totally wrong as it changes all pending into yes whenever I have more than one pending.

Answer 1

When you get the data, save the id of each object on the "id" HTML attribute. You can do this by setting it to something like id="row-id".

Then, when you update, you just use php to grab the id and you can add it to your query.

"UPDATE products SET description='YES' WHERE id=:id"