Arrange blog posts by date

Discussion in 'Web Design and Development' started by Aranince, Nov 28, 2007.

  1. Aranince macrumors 65816

    Joined:
    Apr 18, 2007
    Location:
    California
    #1
    I am writing my own blog software using MySQL and PHP. Currently the way I do it is just use MySQL's datetime columndatatype and the NOW() function. But this is the least bit suitable for recalling the date and time in a somewhat easy to read format. Is there a different way to do this? I also need the date in a format that can be used with RSS.
     
  2. Stampyhead macrumors 68020

    Stampyhead

    Joined:
    Sep 3, 2004
    Location:
    London, UK
    #2
    MySQL has a date formatting function that you call during your query and it can put the date in really any format you want. Here is a link to it on the MySQL website. Post again if you need more help with it.
     
  3. Aranince thread starter macrumors 65816

    Joined:
    Apr 18, 2007
    Location:
    California

Share This Page