Posted 10 April 2006 - 05:02 PM
Whats the SQL statement to get records from past 5 minutes from table, im using a datetime field..
I know it's easy but i had a search and can't find it and in 2 days of work i've locked myself out of 2 booking programs 5 times! think im ill! lol i even wrote the passwords down and put them next to the wrong accounts..
Thanks in advance
Posted 11 April 2006 - 08:36 AM
i also tryed date("YmdHis",
How come that's still showing all records? I think that i have got the wrong idea with the date("Y-m-d H:i:s", bit?
This is how the datetime stamp is in my tabel: 2006-04-11 09:38:00
Posted 11 April 2006 - 12:01 PM
$guests=mysql_query("SELECT count(*) AS `guest_count` FROM hits WHERE member = 'guest' AND `page` = '$page_name' AND DATE_SUB(NOW(), INTERVAL 5 MINUTE) < datetime") or die (mysql_error());
working a treat
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users