i have designed my clients site, and currently you can login and add a client, i then have a few tables which are policies that are sold to the client.
i have created a foreign key between the policy table and the clients table.
what i want to do is display the the date it is up for renewal on a php page, but display it a week before, a month before and 3 months before.
could anyone help me with the php/sql code i would use to get this data displayed?
i assume i would get the date from the server and then do a count or something?