Announcement

Collapse
No announcement yet.

Calculating total number of posts for a given date

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculating total number of posts for a given date

    How is it possible to get the number of total posts for a particular day, via querying MYSQL using PHP? I looked at the posts table structure and the only field addressing a date was the "Dateline" field which is a non-date format number?
    What is a snigglet?

  • #2
    It is a unix timestamp which can be converted either directly through MySQL (see: http://www.mysql.com/doc/D/a/Date_an...functions.html , specifically FROM_UNIXTIME) or in your PHP script (see: http://www.php.net/date )

    Comment


    • #3
      Thanks Tubedogg!!
      What is a snigglet?

      Comment


      • #4
        np

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X