$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); 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; }
你的CODE我试了下,echo $sql;输出是:select * from 'abc201202' union all select * from 'abc201203' union all select * from 'abc201204' union all select * from ''我修改了下输出变成了:select * from twebmailaction_201208 union all select * from twebmailaction_201209 union all select * from twebmailaction_201210 union all我用echo $num = mysql_num_rows($sql); 没有结果。
用你的CODE我试了一下可以查询 几张表的数据条数和是对的。但不知道怎么回事,显示数据框架有,分页好像是对的,就是没有数据库字段内容,还有就是点击下一页后,提示:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in F:\www_local\G03\list5.php on line 88 并且显示数据的框架都没有了。 新手求教育
$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; }
$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;
}
}
$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);
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;
}
新手求教育
$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;
}
while($row=mysql_fetch_row($rec)){
echo "<hr><b>".$row[Username];
}
输出就只有很多直线,没有字段的值?
就差指定字段显示的实现了!不知道怎么遍历指定字段:例如while($row=(mysql_fetch_row($res))){
echo $row[user];
}分页显示user这个字段
echo $row[user];
}像这样分页显示user这个字段怎么没有输出