Author Topic: Most ______ Today.  (Read 4540 times)

0 Members and 1 Guest are viewing this topic.

Offline sumer

  • Newbie
  • *
  • Posts: 10
    • View Profile
Most ______ Today.
« on: January 13, 2007, 10:23:36 PM »
Hi, i am already  fimilar with the sql stuff just wondering how i can
modify the

     
Code: [Select]
  ORDER BY i.image_date DESC
(section in the sql connection)  in order to display:

Most Viewed images Today:
Most Viewed Images This Week:

Top Rated Images Today:
Top Rated Images This Week:

Most Commented images Today:
Most Commented Images This Week:

Top Favorited Images Today:  ( LightBoxed )
Top Favorited Images This Week:

Most Recently Commented Images ( limit 10 ) :
( latest commented image is #1 )

Top Commented(Discussed) Images Today:
Top Commented Images This Week:

« Last Edit: January 14, 2007, 01:38:52 PM by sumer »

Offline tennis-ecards

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: Most ______ Today.
« Reply #1 on: January 29, 2010, 11:35:05 PM »
Hi, i am already  fimilar with the sql stuff just wondering how i can
modify the

     
Code: [Select]
  ORDER BY i.image_date DESC
(section in the sql connection)  in order to display:

Most Viewed images Today:
Most Viewed Images This Week:

Top Rated Images Today:
Top Rated Images This Week:

Most Commented images Today:
Most Commented Images This Week:

Top Favorited Images Today:  ( LightBoxed )
Top Favorited Images This Week:

Most Recently Commented Images ( limit 10 ) :
( latest commented image is #1 )

Top Commented(Discussed) Images Today:
Top Commented Images This Week:



Danach suche ich auch. Hat jemand eine Lösung?