在php中获取当前数据

Question

I have a table, in mysql and it has a column called Date.. I want to take from the database all the rows with date the same as current date. How can I do this? please help me.

I am trying like below:

$sql=mysql_query(select * from table where Date=getCurrentDate());

But it does not function..Please help me

I update my code like this:

$aktivitetet=mysql_query("select * from aktiviteti where Date=CURDATE())");

$rai=mysql_num_rows($aktivitetet);

if($rai>0)
{echo"There are activities on that date";}
else
{echo "There are no activities";}

but I have this error: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\agenda\home.php on line 125

Answer 1

Assuming the date column is of the date type, use CURDATE()

$sql=mysql_query(select * from table where Date=CURDATE());

If that column is a datetime type use Date(), too:

$sql=mysql_query(select * from table where Date(`Date`)=CURDATE());