Trying To Find If Something Is New!!

[crisward]

I want to know if something has changed in a database since I last checked it.

The last checked date and time is stored in a log. I want to write an SQL statement for MySQL which will select all fields where the date is newer than the logdate.

so you would expect:

$sql= 'Select * from Table where datetime > '.$mylogdatetime

to work

but it doesn't..

Both date/time fields were set with now() so the conform to yy-mm-dd hh:mm:ss

I have checked the MySql site a bundle of times but with no help... Can someone please help.

Cris.

[Wien]

date/time fields were set with now() bur how do you build $mylogdatetime. there must be something different in the format

[the_Igel]

And put $mylogdatetime in quotes, if it's in 'yy-mm-dd hh:mm:ss' format.