Find All Posts From Last 24 Hours

[dachshund]

Hi,

 

I'm trying to find all the MySQL entries from the last 24 hours. So far I have this. I just don't know how to take 1 day off the current time.

 

$lastday = date('Y-m-d h:i:s');

$sql = "SELECT * FROM content WHERE `live` LIKE '0' AND `date` >= '$lastday' ORDER BY date DESC LIMIT 40";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){

 

Thanks in advance,

 

Jack

[AyKay47]

try

 

$sql = "SELECT * FROM content WHERE `live` LIKE '0' AND `date` >= SUBDATE(CURRENT_DATE, 1) ORDER BY `date` DESC LIMIT 40";

Edited November 20, 2012 by AyKay47

[Iluvatar+]

The 24 hours before will be a dynamic value so it would have to find out on exercution.....

 

[color=#000000][color=#0000BB]<?php [/color][/color]
$24HoursAgo = $currentTime-3600*24
[color=#000000][color=#007700]?>[/color][/color]

 

myslq..

SELECT *
FROM content
WHERE `live`
LIKE '0'
AND  time   !>  '$24hoursago'
ORDER BY date
DESC LIMIT 40

[Iluvatar+]

$24HoursAgo = $currentTime-3600*24

[AyKay47]

The above post is incorrect and misleading. Until further noted this thread is solved.

[Iluvatar+]

My post?

[Jessica]

Yes, your post. 

 

What the OP asked for can be done entirely in MySQL, and probably should be. Furthermore, your query uses !> which is invalid syntax. You also used the wrong column name. 

 

OP: As an aside, there's no obvious reason to use LIKE on the live column, just compare it with = .