Hi there,
I have two questions,
Firstly, i have a field in my database called 'last_action'. This field contains the date and time of the users last action, in the form of "08 13 02 07:08" or "MM DD YY HH:MM". I know how to select from the database the users active in the last minute (by simply selecting from the database every user that contains "08 13 02 07:08" in the 'last action' field). Hovever, i want to select from the database the users that have been active in the past two minutes, not one. Can anyone help?
Also,
i have two tables, one that contains user data and one that contains a list of posts that users have made. I want to search through the post table, for a variable string, then i need to search through those results to see if the user the post belongs to has been active in the last 2 minutes.
Anyone help? Any guidence would be great, as im pulling my hair out over this!
Cheers
Jonathan
