Re: time comparison issue

[cadex]

I'm by no means an expert, but you helped me in another post so the least I could do is try.

there is a function called DATEDIFF() that should give you the difference between two dates. My other suggestion is to maybe have MySQL create a timestamp instead of PHP. For that you could use CURRENT_TIMESTAMP() or CURTIME().

You could also compare them in your SELECT statement if you wanted using the WHERE clause.

At least this is what I've gathered from what I've read over the last few weeks.

Take Care
Kyle