This topic is locked

Inserting Data in Multiple Tables

1/15/2011 2:07:17 AM
PHPRunner General questions
A
adnankmk author

Hi,

I want to add data in to two talbes using one form. I have adding fields of two tables in one page of add table. when i entered the data in the fields it gives me an error.
<<Record was not addess>>

Item can not be found in collection corresponding to the requested name or ordinal.
I need help to reslove this issue.

Sergey Kornilov admin 1/15/2011

Using a single SQL query you can only update one table. If you need to insert or update data in two tables at once check this article:

http://xlinesoft.com/phprunner/docs/update_multiple_tables.htm