SELECT * FROM dblist WHERE日期？

Question

I have my date from my date input : 20-10-2016

echo "<form method='post' action='rapor.php'>";
echo "<input type='date' name='pickdate' value=".date("Y-m-d")."> <input type='submit' value='Git'>";
echo "</form>";

$pickeddate = strtr($_POST['pickdate'], '/', '-');
echo date('Y-m-d', strtotime($pickeddate)); 

And result of this : 2016-10-20

So far so good..

I need to show only rows date i have picked.

+------+-------------+---------------------+
| name |  mail       | dateandtime         |
+------+-------------+---------------------+
| AAA  |   [e-mail]   | 2016-04-20 06:44:19 |
| BDC  |   [e-mail]   | 2016-10-21 06:44:19 |
| CDD  |   [e-mail]   | 2016-04-10 06:44:19 |
| EED  |   [e-mail]   | 2016-10-20 06:44:19 |
| SAS  |   [e-mail]   | 2016-04-10 06:44:19 |
+------+-------------+---------------------+

thats my result code but....

$result = mysql_query('SELECT * FROM dblist WHERE ('$pickeddate%')  ');

why not working?

Answer 1

It should be

$newdate = date('Y-m-d', strtotime($pickeddate)); 
$result = mysql_query('SELECT * FROM dblist WHERE dateandtime LIKE  "'.$newdate.'%"  ');