PHPСÎÊÌâ - PHP / »ù´¡±à³Ì

PHP code:
<?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


Ä¿µÄ£º²éѯ×ÜÊý¾Ý µ±Ìì µ±ÔÂ

µ«µ±ÌìºÍµ±ÔµÄû³öÀ´

---

$yue1= "select * from contents Where date(date1) = month(now())";

date(date1) = month(now()) ÕâÀïÓÐÎÊÌâ

---

date1ÊÇʲôÑùµÄ¸ñʽ Èç¹ûÊÇʱ¼ä´Á from_UNIXTIME(date1)

---

date(date1) = curdate()ÔÚÕâÀï,Á½¸öµÄÀàÐÍÒ»ÑùÂð?

---

ÏÈ¿´Äã´æµÄʲôÀàÐÍ°É¡£¡£¡£¡£