Date and mysql

julian_chamberl

Hi,

I have a problem with a MySQL query. I have a database with a dates stored in the format of YYYY-MM-DD, which I assume is the standard for MySQL and PHP. I want to be able to search for anything from todays date to anything further but I keep getting problems?

All I need is to check that what is displayed is not older than today(or the day the query is done!)

I am using the code :

$today = date("Y-m-d");
$city = 62;

$result = mysqli_query($con,"SELECT * FROM quotes WHERE pickup_city='$city' AND date <= '$today'");

The problem is, is that it is kicking EVERYTHING out?

Any help appreciated.

Thankyou

Jules

Weedpacket

Your query is asking for records where the date of the quote is "today or before". Do you mean you want the opposite, records from after today?

julian_chamberl

Weedpacket;11041987 wrote:
Your query is asking for records where the date of the quote is "today or before". Do you mean you want the opposite, records from after today?

NO, I want to list everything from the date and everything after! Not before!

Thankyou

bradgrafelman

In other words, you'll want to flip the inequality to match the logic you've described (which is that `date' could be greater than or equal to the given date).