Re: Subject: PHP MySQL question

Surely it would be easier to just write one query which updates the whole entry, regardless of which items have changed ? Might cost a few more electrons, but hey, saves making work for yourself :-) Just make sure to populate your form with the existing data then submit the lot as if it was a new entry (but send the entry ID so you can do the update). Sorry can't be more specific, but your question was rather wooly. Cheers, Neil Smith At 23:49 05/04/2003 +0000, you wrote:

Message-ID: <003d01c2fbcc$f2c6cc10$6401a8c0@p1> From: "ODCS" <odcs@rogers.com> To: "PHP Windows" <php-windows@lists.php.net> Date: Sat, 5 Apr 2003 18:41:57 -0500 MIME-Version: 1.0 Content-Type: text/plain;

        charset="iso-8859-1"

Content-Transfer-Encoding: 7bit Subject: PHP MySQL question I have a database of user inputted information and need to create a page where the user can update their information. The user will log in using their name and password and then be forwarded to a form with all the fields they can update - but what is the best way to write the records to the database. Lets say the user wants to update 3 out of ten fields - would I have to write a query for each field and write them one by one, or is there a better way to do this. Any thoughts on this are appreciated.