I have db that has two tables that I am needing to post the same
information
into both tables, I can't use ID. So I am want to see if there is a sql
statement that will let me or how I can do with a php page.
I'm not a SQL guru, but I'm pretty sure SQL doesn't allow this. (Objects in
PostgreSQL and other object databases essentially allow this, but I suspect
the underlying SQL is iterative.)
But it's pretty simple to do. Just create your insert statement inside a
function with a variable for the table name, then call the function with the
table names.
?
function foo($table) {
$sql=INSERT INTO $table VALUES(...);
//connect to db
$result=mysql_query($sql);
//error handling here
}
foo(table1);
foo(table2);
?
If you need them to have the same ID and you're using autoincrement, you can
add an optional parameter $ID and have the function return last_insert_id if
$ID is not set. Capture the ID the first time you call the function, then
pass that ID as a parameter the second time.
$ID=foo(table1);
foo(table2,$ID);
See http://www.php.net/manual/en/functions.arguments.php for more info on
function arguments in PHP.
-Derek
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php