Skip to main content
July 1, 2011
Question

php insert new records into multiple table

  • July 1, 2011
  • 1 reply
  • 929 views

I have site that i want to use one user name and one password for each member for all of categoreis. I have regisration forms that i want to insert into new records into the two different tables at the same time with out using id.

for sample that i have one video profile and one dating profile both are using in one regisgration forms and want to send profiles into the two different tables with out using unit Id to pass out to other table.

is there is possible to create multiple insert recoreds from one registration forms!

if so, how can i do that!

please help thanks.

AM

This topic has been closed for replies.

1 reply

July 1, 2011

Probably the easist way is to create multiple inserts.

$ins1 = "INSERT INTO tablename (columnname)  VALUES ('$yourvalue')";

$ins2 = "INSERT INTO tablename2 (columnname)  VALUES ('$yourvalue')";

Etc...

Do a search for mulitple mysql inserts....they will fill in the blanks.

Gary

July 1, 2011

so if i want to use dreamweaver behavior extension to allow me to create insert, how can i do that to create TWO inserts into SAME PAGE!, i have treid that and got me errors.

any idea!

AM

July 1, 2011

We would need to see your code to deteremine why you are getting errors..