Page 1 of 1

check against original and modified data

Posted: Tue Feb 24, 2004 9:39 am
by bianster
I have a table named Vehicles(vehno, vehmodel, owner). I will have a form that allows the updating of a user's profile, this profile includes the user's vehicles. Im having trouble figuring out how to check the updated form's vehicle information against the database.

for example:
User modifies the current vehicle info, I need to remove the original vehicle from the Vehicles table. Is there a way to achive this while avoiding the use of session variables or global variables??

Posted: Tue Feb 24, 2004 9:57 am
by pickle
You could store the original information in hidden form variables, then pull that data from the POST vars. Or, if owner is your key and owner doesn't change, you could use an UPDATE query to just change the data other than the key.