Hi,
I am having issues with my php script. I was wondering whether anyone knows how to set-up a filter when doing a MySQL query. My current query is the following:
“SELECT * FROM places WHERE location = '”.$_REQUEST[‘placename’]."’ AND date > 1320968873"
As you can see the lines is requested by the user but considering the amount of data collected it is entered with Unix time stamp. I would like to further enhance the query by altering the date section so that it auto-completes with a time stamp of a roughly 30 seconds before the query is being asked.
Is there any way to do this?
Thanks