Struggling a bit here trying to get my head around something. I'm not a PHP expert, but I feel I've come a long way in the 6 months or so I've been learning it.
Anyway, I thought I would pluck up the courage to build my own custom CMS system, it's going pretty well at the moment, have the major basics covered and are working nice and smoothly, however, I'm having a little bit of trouble with something.
I want to be able to run a MySQL Query using PHP every time that specific page is loaded. Th query I want to run is I want PHP to search the Database for records that have been added in the last 30 minutes... and display certain tables that match that criteria.
Could anyone help me out with this at all? The table type that contains the date and time is "Datetime" (not timestamp) ... I know how to do a basic MySQL query, but seen as the time changes the query would need to change, so I'm slightly confused at how to do this at this point.
All help would be greatly appreciated!