我很难理解这个问题:
MySQL表:tableexample,具有列(flightnumber、company、datearrive、timeleave、timearrive)
我需要生成一个像这样的数组:
Array[0]
- Array[0][1] => 1000
- Array[0][2] => Company A
- Array[0][3] => 2014-05-10
- Array[0][4] => 10:00:00
- Array[0][5] => 15:00:00
Array[1]
- Array[1][1] => 2000
- Array[1][2] => Company A
- Array[1][3] => 2014-05-11
- Array[1][4] => 10:00:00
- Array[1][5] => 15:00:00
Array[2]
- Array[2][1] => 3000
- Array[2][2] => Company B
- Array[2][3] => 2014-05-10
- Array[2][4] => 10:00:00
- Array[2][5] => 15:00:00
Array[3]
- Array[3][1] => 4000
- Array[3][2] => Company B
- Array[3][3] => 2014-05-11
- Array[3][4] => 16:00:00
- Array[0][5] => 19:00:00
然后我需要将这个内容放置在一个HTML表格中:
<p>....................| 2014-05-10|2014-05-11 |</p>
<p>10:00:00 - 15:00:00 | Company A |...........|</p>
<p>10:00:00 - 15:00:00 | Company B | Company A |</p>
<p>16:00:00 - 19:00:00 | ..........| Company B |</p>
我已经完成了以下工作:
在表头中填写了日期,但现在我卡住了……
<thead>
<?php
echo "<tr>";
for ($row = 0; $row < 5;) {
$dia=$array[$row][2];
echo "<th>Dia " . $dia . "</th>";
$i=$row;
for ($rownext = ($row+1); $rownext < 5;){
if ($array[$rownext][2]==$dia){
$i++;
};
$rownext++;
};
$row=($i+1);
};
echo "</tr>";
?>
</thead>
}
后面加上;
,只需要一个}
就足够了,这只是一种风格问题 :) - celeriko