php语句在mysql中查询多张表 并显示在页面上
用php语句实现查询多张表 表的字段是相同的、表名不同。例如：
           abc201202,abc201203,abc201204...表名按月建的表
我新手不知道怎么一次遍历多张表，提取mysql中的数据。    
------解决思路----------------------
$table = array(abc201202,abc201203,abc201204);
$result =array();
foreach($table as $table_name) {
$sql = select * from .$table_name;
$rec =mysql_query($sql);
while($row=mysql_fetch_row($rec)) {
$result[] = $row;
}
}

------解决思路----------------------
$select = array();
$table = array(abc201202,abc201203,abc201204);
foreach($table as $v) {
$select[] = (select * from $v);
}
$sql = join(' union ', $select);
$res = mysql_query($sql);

------解决思路----------------------
$table = array(abc201202,abc201203,abc201204);
$result=array();
$count = count($table)-1;//减去一个数组下标
for ($i=0;$i<$count;$i++){
$sql = $sql. select * from '.$table[$i].' union all;
}
$sql=$sql. select * from '.$table[$count].';
$rec =mysql_query($sql);
while($row=mysql_fetch_row($rec)) {
$result[] = $row;
}