Problem with SQL
[SELECT *, EXTRACT(MONTH FROM dEntryDate) AS month FROM blog ORDER BY nIdCode DESC LIMIT 1;]

Francis' Blog
  Blog Mod is a modified open source diary/journal/blog solution. Visit the Blog Mod for the updated version.
  • Problem with SQL
    [SELECT *,DAYOFMONTH(dEntryDate) AS day,MONTH(dEntryDate) AS month,YEAR(dEntryDate) AS year FROM blog WHERE MONTH(dEntryDate)='2' AND YEAR(dEntryDate)='2010' ORDER BY nIdCode;]
    « February 2010 »
    Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4 5 6
    7 8 9 10 11 12 13
    14 15 16 17 18 19 20
    21 22 23 24 25 26 27
    28            
    Blogs for ,

    No Entries Yet

    		•
    If you like my script, please rate it!
    There are no Blog Entries in this Date Range.
    Introduction

    My New Blog

    Links

    Quality Software
    My Online Address Book
    NeoPhotos
    Blog Mod

    Earn $$$

    PayPopup
    RevenuePilot

    Search Entries


    2010-02-10 16:38:17
    Disclaimer: All entries seen here reflect the author's state of mind at the time of posting and are subjected to changes.
    You have no permission to reproduce whatever is written here. Legal actions will be taken against violators.
    Copyright © 2003. All rights reserved.