[PHP-WIN] Re: Subject: PHP MySQL question

[Neil Smith]

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: <[EMAIL PROTECTED]>
From: "ODCS" <[EMAIL PROTECTED]>
To: "PHP Windows" <[EMAIL PROTECTED]>
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.


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php