如何使用PHP在MySQL数据库表中查找行并只插入一个值？
问题描述：
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"?
例如，我知道我可以创建一个新行并在所有字段中输入值： p>
mysql_query（'INSERT INTO table_name VALUES（“id77”，“some value”）'）;
code> pre>
假设第一个字段（“id77”）的名称是“myID”，第二个字段的名称（“某个值”）是“foo” ... p>
如何使用PHP查找myID = id77的行并将“foo”值更改为“bar”？ p>
div>
答
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").
答
UPDATE ... WHERE.
You should read some books on MySQL first.