I want to query a database for records where the date is equal to, or greater than 90 days.This is what I have so far:\[code\]$format = 'Y-m-j G:i:s'; $date = date ( $format ); // -90 days from today date ( $format, strtotime ( '-90 day' . $date ) ); \[/code\]I'm just a bit unsure now how to structure the MYSQL query. Would it be something like this (I know this is wrong but i'm unsure as to what else to do):\[code\]"SELECT * FROM recurringPayments WHERE lastpmt >= date ( $format, strtotime ( '-90 day' . $date ) ) ";\[/code\]
Mysql Query date >= 90 days
- Thread starter acasperw
- Start date