Well, my query is not working the way I'd hoped

badgoat

I wanted it to display data where the date is equal to or ahead of today... currently, it shows stuff where the date is ahead of today... nothing for today, and I specifically make sure that there is data in the table with today's date!

Query is below:

$sqlquery = "SELECT id, diwtitle, date_string FROM diw_alpha WHERE date_string >= CURDATE() ORDER BY date_string";

eoghain

Is your date_string a timestamp or datetime field? If so is your data for today in the future today or in the past today? (i.e. if you run the query at 12:00pm do you have data for 11:00am or 1:00pm or both). If you only have data for today that is in the past (before the time you run the query) and your field is a timestamp or datetime field then you wont get any data because curdate() returns a timestamp.

badgoat

date_string is a group of 3 variables which are month, day, and year.

$date_string = $depyear . "-" . $depmonth . "-" . $depday;

date_string is stored in my table as a date type in 0000-00-00 format.

eoghain

Depending on your database your date field is probalby a timestamp underneath and thus has it's time part set to 00:00:00 so if you use CurDate() you get back something like 04-15-2005 15:00:23 and since you stored 04-15-2005 only in your datbase the database will add 00:00:00 as the time part and thus you have your problem with your query. All of your "today" dates have a time that is 12:00am and your CurDate() function has a time that is now, so your "today" dates are < the CurDate().

badgoat

I've also tried this:

$joined = date("Y-m-d");

$sqlquery = "SELECT id, diwtitle, date_string FROM diw_alpha WHERE date_string >= '$joined' ORDER BY date_string";

and that returns EVERYTHING.

travelbuff

are you sure the dep_day and dep_month are always 2 digit?

Try echoing the query and see what the date variables print.

badgoat

Yep, depday and depmonth are two digit.. Below are excerpts of the code where they are set:

<select name="depmonth">

<option value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>