Problem with a Select

Hi I have a table named Messages It looks like this Message From To Exampel 1 2 And I also have a table named Users, A short version of it looks like this UserID UserName 1 Me 2 You Now to the problem I want to do a Select from Messages like this

Date Differance in MySQL

Hi Could i in some way find out the seconds between to datetimes I.E. I have a DATETIME in a table and i want to find out how many second it is from that DATETIME to NOW() Does anyone have an idea? /Jonas - Before posting,