Can anybody shed any light on this, maybe I can use MySQL's time functions in my SELECT statement?

Yes, that's exactly what you should do. Something like:

SELECT col1, col2 FROM table 
    WHERE time > (TIMESTAMP() - (48 * 60 * 60))
[download]

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

Note: All code is untested, unless otherwise stated