How do you insert Data into two tables Using one form?

[balamberas]

Hi, Does anybody know how to insert Data into two tables Using one html form?

[ryanbutler]

Usually you can do it by just separating the insert statements with a semi-colon:

INSERT INTO Table() VALUES(); INSERT INTO Table2() VALUES()

[balamberas]

Hi Ryan.

$sql= "INSERT INTO flats (date_posted, type, location, rent, title, image, description, contactEmail, number)
VALUES
(NOW(),'$_POST[type]', '$_POST[location]','$_POST[rent]', '$_POST[title]', '$_POST[image]',
'$_POST[description]','$_POST[contactEmail]','$_POST[number]')";

"INSERT INTO users (email, password, conpass,) VALUES
('$_POST[email]','$_POST[password]','$_POST[confirmPassword]')";

I manage to insert into the flats table but not the users table.
can you see anything wrong with this?

[JavaServlet]

Get rid of last comma after conpass: "INSERT INTO users (email, password, conpass,) VALUES
('$_POST[email]','$_POST[password]','$_POST[confirmPassword]')";

If this is an all or nothing proposition, I would recommend using Transactions assuming the database your working with supports it.

[balamberas]

Hi, I removed the comma but still no luck. I only manage to insert into the flats table.

$sql="INSERT INTO flats (date_posted, type, location, rent, title, image, description, contactEmail, number)
VALUES
(NOW(),'$_POST[type]', '$_POST[location]','$_POST[rent]', '$_POST[title]', '$_POST[image]', '$_POST[description]','$_POST[contactEmail]','$_POST[number]')";

"INSERT INTO users (email, password, conpass) VALUES
('$_POST[email]','$_POST[password]','$_POST[confirmPassword]')";

any ide why?

[JavaServlet]

Hi, I removed the comma but still no luck. I only manage to insert into the flats table.

$sql="INSERT INTO flats (date_posted, type, location, rent, title, image, description, contactEmail, number)
VALUES
(NOW(),'$_POST[type]', '$_POST[location]','$_POST[rent]', '$_POST[title]', '$_POST[image]', '$_POST[description]','$_POST[contactEmail]','$_POST[number]')";

"INSERT INTO users (email, password, conpass) VALUES
('$_POST[email]','$_POST[password]','$_POST[confirmPassword]')";

any ide why?

I assume you have a reason for first statement in a variable and the second one is not. Do you have any error messages after you execute the PHP script? Next step is to test the SQL in the database with test values and see if it works and go from there. For example if using Oracle you can test the statements in SQL Plus.

[balamberas]

Hi, no error massages. if i would put the user table first then i manage to insert into that table but not the flats table. It will only insert into one table

"I assume you have a reason for first statement in a variable and the second one is not".

I dont know what you meen by this. and i inserted manuanly into the database and its inserting data fine.

any other way to insert data into two tables using one html form??

[kurby]

If your using php to execute the command then you have to separate the statements. I believe the mysql_query command in PHP can only execute one statement at a time. Just call mysql_query twice.

[balamberas]

yeah. i solved it today and was going to post the solution. i did this. $sql= INSERT INTO... and then $sql2=INSERT INTO...