How To Insert The Current Time With MySQL
Computing : Learning PHP Finding the current time with mySQL is really simple. The function NOW() will return the current datetime, and therefore is useful for updating datetime fields that store user sign up dates or log in times for instance. You can then use something like the output from this field to calculate a 'show online users's function, which simply works out the interval thirty minutes before this and then selects users who have been logged in within that time period.
Questions about PHP and mySQL:
|
|