RE: [PHP] Inserting Records from a table into another table..

[snip] How can I take records from one table into another based on a criteria.. [/snip] Do a SELECT with your first query for the proper criteria. WHILE you have that data INSERT or UPDATE the other table accordingly. {assuming MySQL for example} $sql = "SELECT a.foo, a.bar FROM table_a a, table_b b WHERE a.foo = b.foo "; $result = mysql_query($sql, $database_connection); while($rows = mysql_fetch_object($result)){ $update = "UPDATE table_b SET bar_column = '" . $rows->bar . "' "; $do_query = mysql_query($update, $database_connection); } HTH! Jay