<?php
$conn=mysql_connect("localhost:3306","root","chenghuam");
mysql_select_db("353wan");
$exec = "select * from contents";
$result = mysql_query($exec);
$num = mysql_num_rows($result);
$tady = "SELECT * FROM contents WHERE date(date1) = curdate()";
$dang1 = mysql_query($tady);
$dang = mysql_num_rows($dang1);$yue1= "select * FROM contents Where date(date1) = month(now())";
$yue2 = mysql_query($yue1);
$yue = mysql_num_rows($yue2);
echo $num."<br / >";
echo $tady."<br / >";
echo $yue."<br / >";
?>输出:
2
SELECT * FROM contents WHERE date(date1) = curdate()
0
目的:查询总数据 当天 当月但当天和当月的没出来
$conn=mysql_connect("localhost:3306","root","chenghuam");
mysql_select_db("353wan");
$exec = "select * from contents";
$result = mysql_query($exec);
$num = mysql_num_rows($result);
$tady = "SELECT * FROM contents WHERE date(date1) = curdate()";
$dang1 = mysql_query($tady);
$dang = mysql_num_rows($dang1);$yue1= "select * FROM contents Where date(date1) = month(now())";
$yue2 = mysql_query($yue1);
$yue = mysql_num_rows($yue2);
echo $num."<br / >";
echo $tady."<br / >";
echo $yue."<br / >";
?>输出:
2
SELECT * FROM contents WHERE date(date1) = curdate()
0
目的:查询总数据 当天 当月但当天和当月的没出来
echo $tady."<br / >";//这个是显示sql语句
echo $dang ."<br / >"; //这个是查询当天所得到的数据$yue1= "select * FROM contents Where date(date1) = month(now())";//你这个sql 语句不能查询当月的数据,date()//这个函数要改成month
正确的是 $yue1= "select * FROM contents Where month(date1)= month(now())";