[SOLVED] Help on Creating one table from many

[Riparian]

Hi

 

I have 10 tables with virtually the same structure containing approx 300 products in each

 

Could someone please tell me how I can create a temporary table by combining all the table based on a flag of in_stock ?

 

Any help is greatly appreciated

[Riparian]

Have found a way so thought I would share it.... if there is a better way I would love to hear it. Cheers

 

mysql_query("Drop Table IF  EXISTS New_Table")or die(mysql_error());

mysql_query("Create Table IF NOT EXISTS New_Table select * from Table1 where Table1.in_stock='T' ") or die('1'.mysql_error());

mysql_query("INSERT INTO `New_Table` SELECT * FROM `Table2` where Table2.in_stock='T' ")or die('2'.mysql_error());

mysql_query("INSERT INTO `New_Table` SELECT * FROM `Table3` where Table3.in_stock='T' ")or die('3'.mysql_error());

mysql_query("INSERT INTO `New_Table` SELECT * FROM `Table4` where Table4.in_stock='T' '")or die('4'.mysql_error());

mysql_query("INSERT INTO `New_Table` SELECT * FROM `Table5` where Table5.in_stock='T' ")or die('5'.mysql_error());