Announcement

Collapse
No announcement yet.

Calculating total number of posts for a given date

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

  • tubedogg
    replied
    np

    Leave a comment:


  • grooveactivator
    replied
    Thanks Tubedogg!!

    Leave a comment:


  • tubedogg
    replied
    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 )

    Leave a comment:


  • 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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X