$tab = array('a','b','c','d','e');
$c = count($tab);
$sql = "";
for($i=0;$i<$c;$i++)
{
$sql .= "select {$tab[$i]}.id as fid,{$tab[$i]}.form_name as fname,{$tab[$i]}.form_number as fnum,{$tab[$i]}.time as ftime from
{$tab[$i]} where {$tab[$i]}.zt=1 ";
if($i != $c -1)
$sql .=" union all ";
}
echo $sql;
$c = count($tab);
$sql = "";
for($i=0;$i<$c;$i++)
{
$sql .= "select {$tab[$i]}.id as fid,{$tab[$i]}.form_name as fname,{$tab[$i]}.form_number as fnum,{$tab[$i]}.time as ftime from
{$tab[$i]} where {$tab[$i]}.zt=1 ";
if($i != $c -1)
$sql .=" union all ";
}
echo $sql;
union all
SELECT id,form_name,form_number,time,zt FROM b WHERE zt=1
*
*
*
*
$s=count($t);
$sql="";
for ($i=0;$i<=$s;$i++) {
$sql.="SELECT id,form_name,form_number,time,zt FROM $t[$i] WHERE zt=1 union all ";
}$sql=substr("$sql",0,-10);
$ttt=mysql_query($sql);