I am writing scripts to load user data into a MySQL database. I have tables in the DB called People and PeopleEmail. The PeopleEmail table stores one email address per record with one of the columns corresponding to the PID of the people table. Is there a way to run a single query that will insert the data into the people table and then take the auto generated pid and use it to insert the email into people email. Right now I envision having to use 3 queries (1 insert into people, a select to retrieve the PID, and then another insert to insert the email.) Is there an easier way?
---------------- Thanks Jefferson Cowart [EMAIL PROTECTED] Support Open Instant Messaging Protocols http://www.petitiononline.com/openIM/petition.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php