> 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