Last 7 days in Select statement

[Anon]

Hey There!,

Newbie here... (just two days of 'experience')

this works... BUT what I really want is a return of all records that have a date (dt_created) of the past 7 days....

$sql = "SELECT * FROM $table_name ORDER BY record_no ";

any help is greatly appreciated.

Fritz Jung

[Anon]

Try the following...

$sql "SELECT * FROM $table_name WHERE TO_DAYS(NOW()) - TO_DAYS(dt_created) <= '7' ORDER BY record_no ";

[Anon]

Thanks so much... You have no idea how long I've been fighting with this.

Blessed Be Well,

Fritz Jung
Co-Founder - The Witches' Voice
http://www.witchvox.com
http://www.witchvox.net

[[deleted]]

Alternatively, making it a few hunderd times more efficient:

SELECT *
FROM table
WHERE date_created>DATE_SUB(NOW(), interval 7 day);

Never convert any data that is in the table to do a comparison, always convert the static parts to match the dynamic parts.
This query saves one to_days() conversion for every record. and if you have 50 million records, that saves hours.