Page 1 of 1

edit a row

Posted: Tue Nov 26, 2002 5:43 pm
by Sevengraff
Ok, i want to edit a specific fileld in a MySQL, how would i go about doing that in a PHP script?

Posted: Tue Nov 26, 2002 5:55 pm
by volka
take a look at http://www.mysql.com/doc/en/UPDATE.html and http://www.mysql.com/doc/en/REPLACE.html

e.g.

Code: Select all

$query = "UPDATE members SET status='ill' WHERE id=".$memberId;
mysql_query($query, $dbConn);

Posted: Tue Nov 26, 2002 6:12 pm
by Sevengraff
wow you reply fast! thanks for the example, it helped. stuff is working like it should! wooo