...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.


By: Stephen

Share on Facebook: On Twitter: TwitterTweet this!

  Reply to How To Insert The Current Time With MySQL

  Receive Our Newsletter




Questions about PHP and mySQL:

Ask question

More Articles:
How to access any website
How to increase eBook sales
How to remove newline characters