Hi there, how is it possible to copy rows from more then one table into a temporary table?
I have 250 city tables named after the country e.g: ca_cities. Now the user has choosen stuff from lets say ca and gm. I want to collect the data into a temp table and then querry this temp table for other stuff. I always get the error: Error: 1060 Duplicate column name 'id' Here is my statement made for a sample of two tables creating the temporary one ( works with one) $stmt =" CREATE TEMPORARY TABLE all_cities SELECT * FROM $DB2.$country_found[0]_cities, $DB2.$country_found[1]_cities "; Does anybody have a clue whats going on here? Thanx for any help Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php