作者layachang (这样笑着很开心!!)
看板PHP
标题Re: [请益] 请问一个有点困难的回圈问题
时间Thu Nov 2 09:57:11 2006
: ------------------------------------------------------------
: |●1手机___________________________________________________|
: |●2皮包___________________________________________________|
: |●3XXXX___________________________________________________|
: |●4$$$$___________________________________________________|
: |●5EEEE___________________________________________________|
: |●6@@@@___________________________________________________|
: |●7%%%%___________________________________________________|
: ------------------------------------------------------------
: |●1RRRRR___________________|●1TRTR_______________________|
: |●2DDDDD___________________|●2ERW________________________|
: |●3SD______________________|●3BT\________________________|
: |●4TR______________________|●4TRTE_______________________|
: ------------------------------------------------------------
: |●1------------------------|●1FSDF-----------------------|
: |●2FEW---------------------|●2!@#!-----------------------|
: |●3#FA---------------------|●3ERE------------------------|
: ------------------------------------------------------------
: |●1------------------------|●1FSDF-----------------------|
: |●2FEW---------------------|●2!@#!-----------------------|
: |●3#FA---------------------|●3ERE------------------------|
: ------------------------------------------------------------
<?
$global_dbh = mysql_connect("localhost","root","") or
die("Couldn't connect with database\n");
mysql_select_db("db_table", $global_dbh) or die("Couldn't select
database\n");
//资料表1 = table1 (只列出前7项)
//资料表2 = table2 (只列出前4项)
//资料表3 = table3 (只列出前4项)
//资料表4 = table4 (只列出前3项)
//资料表5 = table5 (只列出前3项)
//资料表6 = table6 (只列出前3项)
//资料表7 = table7 (只列出前3项)
$tableinfo[0][0] = "table1; $tableinfo[0][1] = "7";
$tableinfo[1][0] = "table2; $tableinfo[1][1] = "4";
$tableinfo[2][0] = "table3; $tableinfo[2][1] = "4";
$tableinfo[3][0] = "table4; $tableinfo[3][1] = "3";
$tableinfo[4][0] = "table5; $tableinfo[4][1] = "3";
$tableinfo[5][0] = "table6; $tableinfo[5][1] = "3";
$tableinfo[6][0] = "table7; $tableinfo[6][1] = "3";
for ($i=0;$i<sizeof($tableinfo);$i++)
{
$sql = "select * from ".$tableinfo[$i][0]." limit 0,".$tableinfo[$i][1];
$res = mysql_query($sql);
$j=0;
while ( $row = @mysql_fetch_assoc($res) ) {
$list[$i][$j] = $row;
$j++;
}
@mysql_free_result($res);
}
// 这时候你要得资料会以二维阵列存在$list中
?>
<table>
<tr>
<td colspan=2>
<table>
<?
for($i=0;$i<sizeof($list[0]);$i++)
{
echo "<tr>";
echo "<td>".($i+1)."</td>";
echo "<td>".$list[0][$i]."</td>";
echo "</tr>";
}
?>
</table>
</td>
</tr>
<tr>
<td>
<table>
<?
for($i=0;$i<sizeof($list[1]);$i++)
{
echo "<tr>";
echo "<td>".($i+1)."</td>";
echo "<td>".$list[1][$i]."</td>";
echo "</tr>";
}
下面懒的写了 不知道是不是你要的东西@@?
--
淡而无味, 可是芬芳, 就当它是酒罢......
没有酒的时候, 到河边去捧饮自己的影子......
没有嘴的时候, 用伤口呼吸....
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.120.139.120