HELP: insert data into 4 mysql tables

[Utech22]

I want to insert data from a html form into 4 tables in a mysql database using php;

How do I go about it, can it be done with one insert statement?

[leoandru]

nope cannot be done with one insert statement. best you use a stored procedure.

[Utech22]

direct me to a tuturial or give me an example because I am kind of new to multiple insert. I only know to insert in one table, but now I have 4 tables and I am stuck;

I am working with dreamweaver 8. This is what I have:

$query= INSERT INTO table1 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table2 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table3 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table4 (col1,col2,..) VALUES ("value1","value2",..);

mysql_query($query)or die(mysql_error()); 

[ToxXxic]

direct me to a tuturial or give me an example because I am kind of new to multiple insert. I only know to insert in one table, but now I have 4 tables and I am stuck;

I am working with dreamweaver 8. This is what I have:

$query= INSERT INTO table1 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table2 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table3 (col1,col2,..) VALUES ("value1","value2",..);
INSERT INTO table4 (col1,col2,..) VALUES ("value1","value2",..);

mysql_query($query)or die(mysql_error()); 

Here is a tutorial : http://www.w3schools.com/php/default.asp

[Utech22]

I checked here already :http://www.w3schools.com/php/php_mysql_insert.asp
I did not find the solution;

[Arch_Angel]

I checked here already :http://www.w3schools.com/php/php_mysql_insert.asp
I did not find the solution;

The 4 INSERT statements that you posted is the correct way to insert data into 4 different tables. What else do you want to know?

[ToxXxic]

I want to insert data from a html form into 4 tables in a mysql database using php;

How do I go about it, can it be done with one insert statement?

INSERT ALL INTO table1 (name,salary)
VALUES('Julie','22500')
INTO table2 (name,salary)
VALUES('Julie','22500')
INTO table3 (name,salary)
VALUES('Julie','22500')
INTO table4 (name,salary)
VALUES('Julie','22500');


for more info check this out: http://www.tizag.com/sqlTutorial/sqlinsert.php

[Utech22]

The 4 INSERT statements that you posted is the correct way to insert data into 4 different tables. What else do you want to know?

not working for me:

This is what I have before I revise it:

$query  = INSERT INTO name (fname,lname,..) VALUES ("Mary","Blige",..); 
$query1 = INSERT INTO address (town,parish,..) VALUES ("Mona","St. Andrew",..); 
$query2 = INSERT INTO phone (cell,fax,..) VALUES (8760001234,8769230002,..); 
$query3 = INSERT INTO computer (brand,type,..) VALUES ("Dell","Laptop",..); 
 
mysql_query($query)or die(mysql_error());
mysql_query($query1)or die(mysql_error());
mysql_query($query2)or die(mysql_error());
mysql_query($query3)or die(mysql_error()); 

I'll still not getting it

[Utech22]

INSERT ALL INTO table1 (name,salary)
VALUES('Julie','22500')
INTO table2 (name,salary)
VALUES('Julie','22500')
INTO table3 (name,salary)
VALUES('Julie','22500')
INTO table4 (name,salary)
VALUES('Julie','22500');


for more info check this out: http://www.tizag.com/sqlTutorial/sqlinsert.php

GETTING AN ERROR :'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use'

[Blunty Killer]

You say it is not working for you, but what errors do you get? Also I noticed you are using integers for phone numbers. You should think of using a type of VARCHAR for that information as a user can enter a number like '876-555-1000' which would fail in insert into an integer column.