//refresh function
//refresh item status
function refresh()
{
$problem = false; $result = mysql_query("SELECT ITEM_ID FROM ITEM WHERE END > NOW() AND STATUS != 'SOLD'"); if($result)
{
while ($row = mysql_fetch_array($result))
{
$act_id = $row['ITEM_ID'];
mysql_query("UPDATE ITEM SET STATUS = 'ACTIVE' WHERE ITEM_ID = $act_id");
}
$result = mysql_query("SELECT ITEM_ID, WINNER_ID, END FROM ITEM WHERE END <= NOW() AND STATUS != 'SOLD'");
if($result)
{
while ($row = mysql_fetch_array($result))
{
$exp_id = $row['ITEM_ID'];
$win_id = $row['WINNER_ID'];
$time = $row['END'];
// Error here. There is only one row has been displayed. There should be 4 rows actully.
// Result: 7 0 2013-04-14 00:00:00
echo $exp_id."<br>";
echo $win_id."<br>";
echo $time."<br>";
if($win_id == 0)
{
mysql_query("UPDATE ITEM SET STATUS = 'EXPIRE' WHERE ITEM_ID = $exp_id");
}
else
{
mysql_query("UPDATE ITEM SET STATUS = 'SOLD' WHERE ITEM_ID = $exp_id");
echo "INSERT INTO ITEM_SOLD VALUES($exp_id,$win_id,'".$time."','N')";
mysql_query("INSERT INTO ITEM_SOLD VALUES($exp_id,$win_id,'".$time."','N')");
}
}
$result = mysql_query("SELECT ITEM_ID FROM ITEM WHERE BEGIN > NOW() AND STATUS != 'SOLD'");
if($result)
{
while ($row = mysql_fetch_array($result))
{
$na_id = $row['ITEM_ID'];
mysql_query("UPDATE ITEM SET STATUS = 'NA' WHERE ITEM_ID = $na_id");
}
}
else
{
$problem = true;
}
}
else
{
$problem = true;
}
}
else
{
$problem = true;
} if($problem)
{
print '<p class = "error">Cannot refresh active item.</p>';
}
}Same query in phpMyadmin, but different result:SQL query: SELECT ITEM_ID, WINNER_ID, END FROM ITEM WHERE END <= NOW() AND STATUS != 'SOLD' LIMIT 0, 30 ;
Rows: 4 ITEM_ID WINNER_ID END
2 4 2013-04-14 00:00:00
4 2 2013-04-13 00:00:00
6 1 2013-04-14 00:00:00
7 0 2013-04-14 00:00:00
Anyone can help me to solve the problem? Thanks a lot!!!PHPMySQLmysql_fetch_array
//refresh item status
function refresh()
{
$problem = false; $result = mysql_query("SELECT ITEM_ID FROM ITEM WHERE END > NOW() AND STATUS != 'SOLD'"); if($result)
{
while ($row = mysql_fetch_array($result))
{
$act_id = $row['ITEM_ID'];
mysql_query("UPDATE ITEM SET STATUS = 'ACTIVE' WHERE ITEM_ID = $act_id");
}
$result = mysql_query("SELECT ITEM_ID, WINNER_ID, END FROM ITEM WHERE END <= NOW() AND STATUS != 'SOLD'");
if($result)
{
while ($row = mysql_fetch_array($result))
{
$exp_id = $row['ITEM_ID'];
$win_id = $row['WINNER_ID'];
$time = $row['END'];
// Error here. There is only one row has been displayed. There should be 4 rows actully.
// Result: 7 0 2013-04-14 00:00:00
echo $exp_id."<br>";
echo $win_id."<br>";
echo $time."<br>";
if($win_id == 0)
{
mysql_query("UPDATE ITEM SET STATUS = 'EXPIRE' WHERE ITEM_ID = $exp_id");
}
else
{
mysql_query("UPDATE ITEM SET STATUS = 'SOLD' WHERE ITEM_ID = $exp_id");
echo "INSERT INTO ITEM_SOLD VALUES($exp_id,$win_id,'".$time."','N')";
mysql_query("INSERT INTO ITEM_SOLD VALUES($exp_id,$win_id,'".$time."','N')");
}
}
$result = mysql_query("SELECT ITEM_ID FROM ITEM WHERE BEGIN > NOW() AND STATUS != 'SOLD'");
if($result)
{
while ($row = mysql_fetch_array($result))
{
$na_id = $row['ITEM_ID'];
mysql_query("UPDATE ITEM SET STATUS = 'NA' WHERE ITEM_ID = $na_id");
}
}
else
{
$problem = true;
}
}
else
{
$problem = true;
}
}
else
{
$problem = true;
} if($problem)
{
print '<p class = "error">Cannot refresh active item.</p>';
}
}Same query in phpMyadmin, but different result:SQL query: SELECT ITEM_ID, WINNER_ID, END FROM ITEM WHERE END <= NOW() AND STATUS != 'SOLD' LIMIT 0, 30 ;
Rows: 4 ITEM_ID WINNER_ID END
2 4 2013-04-14 00:00:00
4 2 2013-04-13 00:00:00
6 1 2013-04-14 00:00:00
7 0 2013-04-14 00:00:00
Anyone can help me to solve the problem? Thanks a lot!!!PHPMySQLmysql_fetch_array
解决方案 »
- 请问怎么在3000W条记录中快速按照价格区间查询呢?
- 有关Json_encode()函数的问题
- 关于使用PHP制作仿IE工具栏管理的功能(内详有示意图)
- 这样实现防刷新的计数器可以吗?
- 一般BBS的登录form在?????.php里面,我想把它拿到首页index.html里面。有哪位大哥举例赐教小弟啊。
- 另:如何实现Big5与GB的转化?
- 请教一个"从word或excel中复制文字,保存到数据库中时,显示的问题"。谢谢
- 紧急求救
- header函式怎样将数组参数传送到下一页?
- number_format,round,sprintf
- php mysql我是新手 网上找不到 不要模板和框架
- php 查询sql 输出的数组问题求助
I don't quite understand... Any suggested solution?
(I don't have chinese input software on this computer, sorry about that...)
Thanks for taking time to answer my question. But I am new to php and mySQL, I cannot solve this myself.
Can you just simply give me a solution?
I am so sorry!
Something is wrong in my database connection header file...
I choosed the wrong database. Now it is fixed.
I am so sorry!
Something is wrong in my database connection header file...
I choosed the wrong database. Now it is fixed.congratulation