Thanks Chris!
Appreciate the help!
Eustace
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, May 01, 2006 3:23 AM
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] multi-table insert
Eustace wrote:
> Hello everybody!
> I am very much a newbie in PHP, but enjoying the learning process.
> Here and there I get tangled in the logic of certain problems. Anyway,
> I have a database about interns and this database has multi-tables
> told data of interns, for example personal information, education
> qualifications, computer skills, languages etc. The relationship of
> the tables is based on the intern's username.
> What I am trying to do is have a form, which an intern can fill in so
> that details are inserted into the database. Since I am populating a
> number of tables in one go, what's the best way to implement this? The
> main table is the personal information one, which has the username as
> primary key, and the rest of the tables username is the foreign key.
> Obviously I need the to pick the username from the main table and
> insert it into the other tables. How best can I do this?
No databases will do this automatically for you (whether you use mysql,
sqlite, postgresql or something else), so you need to create multiple
queries:
mysql example:
$query = "insert into users(username) values ('my_username')";
mysql_query($query); $userid = mysql_insert_id();
$query = "insert into table2(userid) values('$userid')";
postgres example:
$query = "select nextval('user_sequence') AS nextid"; $result =
pg_query($query); $row = pg_fetch_assoc($result); $userid = $row['nextid'];
$query = "insert into table2(userid) values('$userid')";
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/328 - Release Date: 5/1/2006
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php