[請益] 請教mysql_fetch_assoc的用法?
請教各位高手,小弟目前正在撈資料庫的資料,只要是要產生以下格式的資料
01,25415,23542-->三個數值分別代表"小時-今日的值-昨日的值"
我想撈出今日24小時的狀況做比較,程式碼如下
<?php
mysql_select_db($database_curve, $curve);
$nowday=date("Y-m-d");
$query_net = "SELECT * FROM net WHERE date='$nowday' order by time ASC";
$net = mysql_query($query_net, $curve) or die(mysql_error());
$row_net = mysql_fetch_assoc($net);
$totalRows_net = mysql_num_rows($net);
$query_yes_net = "SELECT * FROM net WHERE date=(DATE_SUB('$nowday', INTERVAL
1 DAY)) order by time ASC";
$yes_net = mysql_query($query_yes_net, $curve) or die(mysql_error());
$row_yes_net = mysql_fetch_assoc($yes_net);
$totalRows_yes_net = mysql_num_rows($yes_net);
do{
$today_net=$row_net['net'];
$today_X=substr($row_net['time'],0,2);
$yes_net=$row_yes_net['net'];
echo "$today_X,$today_net,$yes_net \n"; <------這邊是印出資料的地方
}
while ($row_net = mysql_fetch_assoc($net));
mysql_free_result($net);
mysql_free_result($yes_net);
?>
問題在於我用do~while迴圈去跑只能跑出類似下面的數值,
01,21000,25462 02,22520,25462 03,21450,25462 04,19000,25462
等於說昨日的值都是固定不變的,與資料庫的值不符合,因為迴圈
只要是$row_net = mysql_fetch_assoc($net)產生的值,
不知道要怎麼作才能把另外一個資料集的資料放進去呢???以便產生昨日的正確值
請大家幫幫忙~謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 220.134.184.241
推
09/05 03:13, , 1F
09/05 03:13, 1F
→
09/05 03:14, , 2F
09/05 03:14, 2F
→
09/05 03:14, , 3F
09/05 03:14, 3F
→
09/05 20:41, , 4F
09/05 20:41, 4F