24 second delay on server?

[defroster]

Hello, I am a bit puzzled 

 

If I schedule a post to show on my website at exactly time 10:00:00 the post will only show when the time hits 10:00:24 = 24 seconds late!!

 

Any ideas why the post always will show with a 24 second delay? Is there one time for the apache server and one time for the mySQL server? If that is the case, how can I sync them?

 

- I have tried restarting the server and there was no change..

Thanks a million /df

[PFMaBiSmAd]

You likely have an error in your code that is determining when to show a post (usually a wrong formatting character.)

 

Post your code/query that is responsible for matching/retrieving the offending result along with a sample of the data.

[defroster]

Ok, thanks for reply.

 

The code is:

$sql = "Select videos.*, categories.cat FROM videos, categories
WHERE videos.cat_id = categories.id AND videos.status =1 AND videos.dateposted <= now() ORDER BY dateposted DESC
LIMIT $start, $limit";

 

And the format of the table in the database is 'datetime' and the value stored looks like this:

2011-12-06 12:53:32

Thanks for help