mysqli query by date value

Question

I have the following mysqli query:

$query = "SELECT * FROM `products` ORDER BY product_price ASC";

I would like to only query posts which have a certain date or a date greater than the one set below in $date. I have tried the following:

$date = '2016-02-28';
$query = "SELECT * FROM `products` WHERE last_updated > $date ORDER BY product_price ASC";

Is this the right approach? My dates are currently stored like this:

2016-03-01 07:18:17

Any help would be appreciated.

can you explain how this is a duplicate of http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php ? — danyo, Mar 01 '16 at 11:34
It's a duplicate because the way you are running a query is wrong — Your Common Sense, Mar 01 '16 at 11:40

score 0 · Accepted Answer · edited May 23 '17 at 12:23

0

SELECT * FROM `products` WHERE `date` > '2012-11-18' ORDER BY `product_price` ASC;

if you want to have a go try this jsfiddle

This answer will probably cover your question

edited May 23 '17 at 12:23

Community

answered Mar 01 '16 at 11:41

DevilCode

1 Answers1