PDA

View Full Version : Inserting Form


morrellaberdeen
05-26-2005, 05:42 AM
I am aware of building Forms using Dreamweaver that can insert or update a single database table at a time.
I wish, however, to create a single form that, upon submission/posting, would simultaneously update two database tables. Is that possible? If possible, how is such a form built?

tmilewski
06-20-2005, 07:59 AM
All you need is one form like you had and then you need to create two queries (one for each table) and use the $_POST variables from the form appropriately for each query and you can update two tables at once.

Make sure you mysql_escape_string() all variables being entered into your database to ensure your safety from SQL INJECTION.