Fetch records only for today's date by using PHP & Mysql
You have to use DATE() function:

SELECT * 
  FROM table
 WHERE DATE(col1) = DATE(NOW()) -- date parts are equal (HH:MM:SS are dropped)
 ORDER BY col1 ASC
;


Keep in mind that such condition can't be covered by index and can be slow/very slow on a big tables. If the query performance is inappropriate you have to store the date and time parts separately. Columns of types DATE and TIME can be indexed by single multicolumn index.