If I understand your question correctly, an UPDATE query should be all you need. UPDATE tablename SET columname='value' WHERE someid='somenum'; I'm assuming you don't have the MySQL doc. Check mysql.com for the docs for your version of the server. Rich Hutchins, CIW Professional Sr. Technical Writing Administrator Getinge USA 1777 E. Henrietta Rd. Rochester NY 14623 585-272-5072 www.getingeusa.com > -----Original Message----- > From: Jeroen Wasteels [mailto:jeroenwasteels@xxxxxxxxx] > Sent: Friday, January 09, 2004 1:24 PM > To: php-db@xxxxxxxxxxxxx > Subject: Need help replacing one record > > > Is there a way to change the information in one record of a > database, for > example the password, without having to open the entire row, > delete it, and > then add it with $row_data[name] and all and the $newpass as changed > password? > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php