adding to two tables
Posted: Thu Jul 08, 2004 12:38 pm
I have a database which has a customer table and a booking table. When a new customer registers, an insert query is sent which adds them to the customer database. I then need thier CustNo to put into the booking table. CustNo is an autonumber form the customer table.
I tried doing a selct where the email address is the same as the email address just added ( held in $email) and then I want to do anther insert into the other table.
This is not working for the second database and I don't seem t be retrieving anything from the customer table when using the select.
Does the table need refreshing or anything before I try and retrieve the record I just added?
any help appreciated
Angie
I tried doing a selct where the email address is the same as the email address just added ( held in $email) and then I want to do anther insert into the other table.
This is not working for the second database and I don't seem t be retrieving anything from the customer table when using the select.
Does the table need refreshing or anything before I try and retrieve the record I just added?
any help appreciated
Angie