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

How To Issue Date Queries With MySQL

Computing : Learning PHP

Many people who know PHP at some stage need to work with a database.

And a typical interaction will be setting membership timeouts for a user database.

However most will not know about the powerful time and date functions you get with mySQL and will therefore spend time manipulating the date or time with PHP and then issuing a query.

However there are mySQL functions out there that will take the strain for you, for instance either adding to the date, subtracting from the date or even working out the difference between two dates.

To add to the date, for instance, you can simply use the adddate() function: notice the three d's, if you get confused use the synonymous date_add() function.

You pass to this function the interval as relevant, for instance 1 MONTH, and thus you save having to do any calculations with PHP first.

By: Stephen

Share on Facebook: On Twitter: TwitterTweet this!

  Reply to How To Issue Date Queries With MySQL

  Receive Our Newsletter

Questions about PHP and mySQL:

Ask question

More Articles:
How to find more details about your files
How to get free PR from your free ebook
How to remove Spyware programs