日期:2014-05-17 浏览次数:20569 次
$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; }