我正在尝试显示 2 个日期之间具有created_at
日期的行数。
这是我的代码:
$result=mysql_query("select * from payments
where created_at between '2013/10/01 00:00:00' and '2013/10/30 00:00:00'")
or die('You need to add an administrator ' );
$counter = mysql_query("select * from payments
where created_at between '2013/10/01 00:00:00' and '2013/10/30 00:00:00'");
$row = mysql_fetch_array($result);
$id = $row['id'];
$num = mysql_fetch_array($counter);
$countjan = $num["id"];
然而当我回声时
<?php echo"$jan";?>
这表明0
我知道如何让它工作
P.s在此日期范围内有1行
SELECT COUNT(*) FROM your_table WHERE created_at >= '2013/10/01 00:00:00' AND created_at <= '2013/10/30 00:00:00'
您可以像这样查询:
SELECT COUNT(*) FROM your_table WHERE created_at >= '2013/10/01 00:00:00' AND created_at <= '2013/10/30 00:00:00'
顺便说一句:您应该使用MySQL日期格式或时间戳。
试试这个
$res=mysql_query("SELECT * FROM your_table WHERE created_at >= '2013/10/01 00:00:00' AND created_at <= '2013/10/30 00:00:00'");
if($res)
{
$count=mysql_num_rows($res);
echo $count;
}