I have a table with a timestamp column which is automatically updated with now() when the records are inserted.
However, on the page where I want to be able to view the info I need to give the option to view info from within a certain amount of time.
So in the select I need to put something like:
Code: Select all
where timestamp < now() + 28Can anyone also offer some guidance on providing a "delete" link for each of the records returned. They do have a unique ID
Many thanks in advance