四十三章 PHP 制作数据透视表

echo "<input size='10' value=''/>";
$sql3= "SELECT FROM cs GROUP BY date";
$ret3 = mysql_query($sql3, $link);
while ($row3 = mysql_fetch_assoc($ret3)) {
echo "<input size='10' value='{$row3['date']}'/>";
}
echo "<br>";
$sql= "SELECT FROM cs GROUP BY name";
$ret = mysql_query($sql, $link);
while ($row = mysql_fetch_assoc($ret)) {
echo "<input size='10' value='{$row['name']}'/>";
$sql2= "SELECT FROM cs GROUP BY date";
$ret2 = mysql_query($sql2, $link);
while ($row2 = mysql_fetch_assoc($ret2)) {
$sql4= "SELECT FROM cs where date='".$row2['date']."'and name='".$row['name']."'";
$ret4 = mysql_query($sql4, $link);
$row4 = mysql_fetch_assoc($ret4) ;
echo "<input size='10' value='{$row4['suliang']}'/>";
}
echo "<br>";
}