Re: [PHP] Multiple Tables -add, edit, delete

Thanks Dan Paul Analysis & Solutions wrote: > Oh, yes! I forgot about deleting countries that have been unchecked! > Hmm... Lock the table to prevent people from reading from it, delete > all records for that company, then loop through and insert the new > data, then unlock the table. > > --

Re: [PHP] Multiple Tables -add, edit, delete

On Fri, Jul 12, 2002 at 10:57:08AM +0200, Paul Dionne wrote: > > Problem: How do I display all the tblCountriesOfOperation for one > tblContacts record SO THAT MULTIPLE COUNTRIES CAN BE ADDED OR DELETED FOR > THAT RECORD? Use an option list with multiple selections. My SQL Solution does this

Re: [PHP] Multiple Tables -add, edit, delete

Oh, yes! I forgot about deleting countries that have been unchecked! Hmm... Lock the table to prevent people from reading from it, delete all records for that company, then loop through and insert the new data, then unlock the table. --Dan -- PHP classes that make web desig

[PHP] Multiple Tables -add, edit, delete

Hello all. Hope you are doing well. I would like some guidance here, meat of problem is in all caps: tblContacts -basic contact information on companies/non-government organizations/media outlets... tblCountriesOfOperation (tblContactsID, CountryID) -countries that tblContacts operate in. tblI