...Beauty, cleaning, DIY tips and more - free to join!
   Login   Contact us   Site map   Puzzle Club   Ask a question    Newsletter

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.


Profile image!
By: Stephen

  More about PHP and mySQL

  Reply to How To Insert The Current Time With MySQL

  Receive Our Newsletter

  Send to friend

PHP and mySQL picture



Questions about PHP and mySQL:

Ask question

More Articles:
How to get suggested Google searches
How to increase your eBook sales
How to install the Google Toolbar