作者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