Display by Date

[JSHINER]

Trying to figure out how to show records that are current day & beyond - no past. I don't want them to delete from the database, I just want the page to display records that are either current date or future.

 

Any help would be much appreciated.

 

 

Thanks

[Orio]

Do you have some sort of column that holds a date or a timestamp? In what format?

 

Orio.

[majocmatt]

I'll assume your just using YYYY-MM-DD, the DATE format in a database. If not, you can adapt your timestamp to the following:

 

Create a variable for $now where

 

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

 

And query the database

 

SELECT * FROM myTable WHERE date >= $now

[JSHINER]

Sorry - should have included that:

 

I have a field "date" and the date is entered by the user in the 00/00/2007 format.

 

I need a page that will display results that are either the current date, or future dates.

[grimmier]

 $sql='SELECT * FROM `db_name` WHERE `date_field` >= "low_range" ORDER BY `date_field` DESC'; 

 

try something like that, filling in the db_name, date_field, and low_range with your variables.

[grimmier]

Sorry - should have included that:

 

I have a field "date" and the date is entered by the user in the 00/00/2007 format.

 

I need a page that will display results that are either the current date, or future dates.

 

is the date stored as in DATE format in the DB or as a VARCHAR?

[JSHINER]

It can be stored as either - I haven't created it yet.

 

So low range - how can I have that be the current date?

[grimmier]

It can be stored as either - I haven't created it yet.

 

So low range - how can I have that be the current date?

 

$low_range =  date("Y-m-d"); //will set the low range to the current date, formatted in yyyy-mm-dd format (which is standard for mysql db's anyway)

 

You can still allow the users who do the inputting to enter their dates in mm-dd-yy format if you want, and reformat it before inserting it, into the DB, thats the method i use personally.

 

$low_range =  date("Y-m-d");
$sql='SELECT * FROM `db_name` WHERE `date_field` >= "'.$low_range.'" ORDER BY `date_field` DESC'; 

 

[JSHINER]

How would I re-format before inserting ?

[grimmier]

http://www.phpfreaks.com/forums/index.php/topic,127739.15.html

 

thats the thread i started when i was wondering the same thing. the solution is twards the end.