> Hi there,
> how is it possible to copy rows from more then one table into a temporary
> 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_cities,
> Does anybody have a clue whats going on here?
> Thanx for any help
try to use coulumn names not * and rename columns
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php