[SOLVED] show users that were on within last 24 hours

[marksie1988]

i have created some code from information i found on the internet to show users that have been online within the last 24 housr but i keep on getting errors, i think that the mysql query is not working as an account that hasnt been logged on since it was created still shows when running on phpmyadmin. i have looked every where and have found loads of different ways of doing this but i cant seem to get any to work. here is my code

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/marksie/public_html/blacklime/inc/footer.blc

 

<?php
$query = "SELECT * FROM `users` WHERE `timestamp` < NOW(), INTERVAL 1 DAY";
	$result = mysql_query ($query);
   
			while ($row = mysql_fetch_assoc ($result)) {
		$id = $row['id'];
		$uname = $row['username'];

		echo"<ol><a href=\"../login/userinfo.blc?user=$uname\">$uname</a></ol>";
		}
?>

[Barand]

to get users logged in last 24 hrs

 

SELECT * FROM `users` WHERE `timestamp` > NOW() - INTERVAL 1 DAY

[marksie1988]

this does not work, i am presuming that this query works with unix timestamp?

 

 

SELECT *

FROM `users`

WHERE `timestamp` > NOW( ) - INTERVAL 1

DAY

LIMIT 0 , 30

 

[Barand]

if it's unix timestamp then

 

SELECT * FROM `users` WHERE FROM_UNIXTIME(`timestamp`) > NOW() - INTERVAL 1 DAY

[marksie1988]

Great thanks loads that works