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?

Jefferson Cowart

Support Open Instant Messaging Protocols

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to