PDA

View Full Version : Mysql and record setting


rico1931
07-31-2008, 08:13 PM
Not sure if this the right place to ask this but i'm going to throw it out there. I am using 2 tables in a mysql database. One table gets updated via a form on the website. Now I have a second table that I want updated but I want it updated with one field from the form. Is there a way to update one table with all elements from the form and the other table to be updated with one element from the form? Do I have to write a store procedure for this?

Thanks!

edbr
08-01-2008, 01:07 AM
store procedure
you mean write some code? yes, an additional insert query