Hello, Forgive me for what is probably a fairly novice question as I am still fairly new to MySQL. I have constructed the following database with three tables:
CREATE TABLE members ( member_id int DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, first varchar(20) NOT NULL, last varchar(20) NOT NULL, position varchar(20), organization varchar(35), address varchar(255), postal_code varchar(7), county varchar(15) NOT NULL, phone varchar(20), fax varchar(20), email varchar(40), website varchar(50), member_type varchar(20) NOT NULL, on_directory char(1) NOT NULL DEFAULT 'N', on_website char(1) NOT NULL DEFAULT 'N', description BLOB ); CREATE TABLE skills ( skills_id int default '0' not null auto_increment primary key, member_id int not null references members(member_id), name varchar(20) NOT NULL, schooling varchar(20) NOT NULL, certifications varchar (20) NOT NULL, decription BLOB ); CREATE TABLE committees ( committees_id int DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, member_id int not null references members, name varchar(25) ); I would like the member_id field present in all of the tables to link the skills and commitees to a specific member_id. I was looking at the last_insert_id() function as a possible way to do this as initially all of this information will be entered at once. What is the best way to find the member_id that was just created in the members table and insert it into the skills table and the committees table when adding the information about those members? I am using PHP and MySQL 3.23.38 running on FreeBSD / Apache(PhP4). Thanks. Matt Rudderham "Bonum volens duceris in Tartarum" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
