Big Webmaster

  • a do follow blog

  • bots
  • code
  • ecommerce
  • misc
  • software
  • tips
  • tools
  • wordpress

MySQL Query on timestamp using PHP

on March 11, 2010 - 0 Comments
code

standard timestamp field in MySQL

In this example I had to create a query only to display orders for the last 90 days. The orders table is using a standard MySQL timestamp field to store the date of the order. I made timestamp indexed since we will be doing this query against this field. I figured the easiest way was [...]

Read more ยป

Share your thoughts!

  • Recommended Theme

  • Recent Posts

    • Restore the WordPress Admin Menu
    • Redirect directory and contents using htaccess
    • Twenty Ten and Featured Content Gallery
    • Frugal Theme Review
    • MySQL Query on timestamp using PHP
  • Recent Comments

    • trau on Redirect directory and contents using htaccess
    • Jeff on WordPress Automatic Update with 1and1
    • Susan McNaughton on WordPress Automatic Update with 1and1
    • bigw on WordPress Automatic Update with 1and1
    • Mat on WordPress Automatic Update with 1and1
  • Archives

    • September 2010
    • August 2010
    • July 2010
    • April 2010
    • March 2010
    • January 2010
    • December 2009
    • November 2009
    • September 2009
    • August 2009
    • May 2009
    • April 2009
    • February 2009
    • December 2008
    • November 2008
    • September 2008
    • July 2008
    • June 2008
    • April 2008
    • February 2008
  • Follow Me On Twitter

Powered by frugal


Copyright © 2010 Big Webmaster