Can one <form> submit data to multiple tables?

[jip]

Am I able to use a single form to write data to multiple tables in my database using php/mySQL?

[Michael Fesser]

.oO(jip)

>Am I able to use a single form to write data to multiple tables in my
>database using php/mySQL?

Sure. You can do whatever you want with the submitted data in the form
processing script, there are no restrictions of any kind.

Micha

[visuality]

You'll need to write more than one query, but once you capture the POST data to
your script you can use it as often as you like. You mean something like
this?...

 /* get post data from form */ $foo = $_POST['bar'];  /* insert
it */ $query1 = 'INSERT INTO table1 VALUES ($foo)'; mysql_query($query1);  /*
insert it again elsewhere */ $query2 = 'INSERT INTO table2 VALUES ($foo)';
mysql_query($query2);

You could also establish multiple DB connections
to use the data in queries to different DBs.

[jip]

Thanks for the feedback!