Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > Beginning PHP
| Search | Today's Posts | Mark Forums Read
Beginning PHP Beginning-level PHP discussions. More advanced coders should post to the Pro PHP forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning PHP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 22nd, 2007, 01:42 PM
Registered User
 
Join Date: Nov 2006
Location: Orange Grove, TX, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default updating SQL tables

I have a multi-column customer master file for which to update I have created a lengthy form. I retrieve and display on the form info from the record to be changed. I invite the user to enter the changed fields and submit the form.

Now I need an efficient way to detect what fields changed and validate the only the new input data, then update only those fields.

Any help greatly appreciated - I am a novice, just learning PHP and MySQL.
 
Old January 24th, 2007, 11:53 PM
Friend of Wrox
 
Join Date: Oct 2003
Location: colombo, WP, Sri Lanka.
Posts: 479
Thanks: 0
Thanked 3 Times in 3 Posts
Send a message via MSN to surendran Send a message via Yahoo to surendran
Default

leopardj,
in my Experience i did not do this type work, we can check each one by one, but if you found a solution let me know,

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com
 
Old January 29th, 2007, 06:42 AM
Authorized User
 
Join Date: Jan 2007
Location: Lisbon, , Portugal.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

why don't you update the whole form, all the time, using one standard update query for all the form and all the table fields together?
It would save you some time!

Visit my page: http://www.webrickco.com




Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Tables Brendan Bartley Access 1 December 20th, 2006 10:42 AM
Updating data in a subform when tables change. Paulsh Access VBA 1 October 6th, 2004 03:49 PM
ADO - Updating two tables? BradLee31 Pro VB 6 2 May 19th, 2004 05:39 AM
Updating Two Tables from Form Input PamS Access 6 October 30th, 2003 02:46 PM
Updating Multiple Tables with 1 Dreamweaver Form stephaniejones Dreamweaver (all versions) 0 July 9th, 2003 09:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.