Author Topic: Top Images of month?  (Read 3759 times)

0 Members and 1 Guest are viewing this topic.

Offline dosensteck

  • Full Member
  • ***
  • Posts: 160
    • View Profile
Top Images of month?
« on: June 13, 2005, 04:59:55 PM »
is it possible to show the top image statistics of a month?

for example: top.php?month=may

similarly as: top.php?catid=xx

ps: sorry for the bad english

Offline dosensteck

  • Full Member
  • ***
  • Posts: 160
    • View Profile
Re: Top Images of month?
« Reply #1 on: June 17, 2005, 12:39:45 AM »
hm, keiner eine idee dazu?

Offline Loda

  • Sr. Member
  • ****
  • Posts: 353
    • View Profile
    • Fotosucht Schweiz
Re: Top Images of month?
« Reply #2 on: July 20, 2005, 06:56:06 PM »
hallo!
ersetze mal diese zeile:
Code: [Select]
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id durch diese:
Code: [Select]
WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND i.cat_id = c.cat_id AND i.image_date >= ".(mktime(0, 0, 0, date("m")  , 1, date("Y")))."
ich glaube, es müsste gehen..
ansonsten mal die suchfunktion benutzen.