如何使用PHP在MySQL数据库表中查找行并只插入一个值？

Question

For example, I know I can make a new row and enter values into all fields doing this:

mysql_query('INSERT INTO table_name VALUES ( "id77" ,"some value" )'); 

Assuming the name of the first field ("id77") is "myID" and the name of the second field ("some value") is "foo"...

How can I use PHP find the row with myID = id77 and change the "foo" value to "bar"?

Answer 1

mysql_query("UPDATE table_name SET foo = 'bar' WHERE myID = 77");

I assume that you are using an integer (77) for your IDs instead of a string value ("id77").