I have table with tasks at particular date. To retrieve task of particular date I am passing date through input box (POST).
Now I am running mysql query as:
query = "select * from task_table where task_date=$date";

But it wont return a result.
Please, help me in order to obtain particular result by date.

task_date is "date" type column storing date in format "Y-M-D".

This should do:

select * 
from task_table 
where date(task_date)=date('$date')

the "date(task_date)" should not be necessary, but in case you have hour/minutes/seconds info, they will be stripped out, making your query match the whole day, and not just 1 millisecond in it.
http://dev.mysql.com/doc/refman/5.1/...functions.html