inserting into multiple tables using php

Anon

i understand that

$query = "insert into student_table(ssn,fname,lname,mi,dob,phone,email)
values('$ssn','$fname','$lname','$mi','$dob','$phone','$email')";

now... that's from ONE table. the student table. i need to be able to insert into three different tables.

one is for classes (class_date, class_time, class_description) and another for passwords (student_password)

how would i do that?

Anon

With 3 different insert statements. Why would you want to try and do this any other way?

If you are worried about all of them going off perfectly then you need to work with transactions, and you'll need a database that can handle them.

pinoyvibes

thanks for the example of the code... helps out a lot.

and yes, i am using mysql so your code will work.

i was not sure if i could create several queries in one php program. my fault for thinking that php wasnt versatile.

thanks again chris and rob.

-arnold

Anon

rob, thanks for the quick reply.

i want to do three inserts onto one webpage... i only know how to do one insert per webpage -- but my application needs to have one webpage that'll be able to insert into three different tables.

-arnold

Anon

rob is correct. just write 3 statements

$query1 = "insert into student_table(ssn,fname,lname,mi,dob,phone,email)
values('$ssn','$fname','$lname','$mi','$dob','$phone','$email')";

$query2= "insert into classes....";

$query3= "insert into users...";

//assuming you are using mysql...
$result1=mysql_query($query1);
$result2=mysql_query($query2);
$result3=mysql_query($query3);

Anon

How do you relate the ID fields between the tables?

I have a DB with 15 tables. My Customer section consists of three tables... customer_name, customer_address, and customer_contact. Each table has a Primary key ID field.

When I submit my new customer form, I want to insert the data in the appropiate tables and relate the ID fields so I can have one customer name with multiple addresses and contacts.

Example of code would be helpful or a reference link.

Thanks,
Bob

Anon

AFAIK, you can insert the data in all three tables, but you have to have the ID set to UNIQUE for your name table, but not for the others, since you want multiple records. You then relate the tables using JOIN commands.

hth,
chrisg