<?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
目的:查询总数据 当天 当月但当天和当月的没出来
解决方案 »
- 51PHP图像处理程序
- 新手问个问题,为什么服务器返回的状态码是500
- 急!!!有人知道如何在PHP中,使用pdflib,向PDF中插入一个条形码吗。
- 关于php的状态函数问题
- 帮我看一下转义问题.谢谢了
- 急 php版的ewebeditor在哪里可以下呀?
- 紧急求助:需注册大量的域名(.com和.com.cn),寻最低价格
- 高分求教mkdir,在线等候,有效即给分!!!!!!!!!!!!!!!!
- 请问Mysql数据库超过多大速度会明显变慢?另外如果结构一样的的记录越来越多的时候
- php能实现中转服务吗?即client -> serverA -> serverB;cgi可以实现吗?请高手指点,多谢!分可以再加
- 突然发现我并不适合……
- 深夜散分,
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())";