posted 16 years ago
i have two forms and i am fetching the data from those two forms. i want to store the data of these two forms in two different
tables.
the problem is i want to maintain a common column taht is tranaaction_id , in both tables. also if i want this transaction_id to be generated dynamically i.e. my databse should generate it.
also both form data need to be inserted together. that is either both are inserted or none are inserted.
i am using MYSQL database.
can any one please suggest me the solution.
Thanks and regards.