Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Apr 13, 2006
  • Posts: 14

  Posted: May 23, 2005 - 12:51 PM

  I try to create a block that shows the top news submitters on the last [period time] and it doesn't show anything :S
  
  This is the SQL that i execute...
  
  

  Code

  $newDayRaw = (time()-(86400 * 7));
  $newDB = date("Y-m-d", $newDayRaw);
  
  $sql  = "SELECT $userscolumn[uid], $userscolumn[uname], $userscolumn[counter], $newscolumn[time] FROM $userstable, $newstable AND $newscolumn[time] LIKE '%$newDB%'";

  
  
  Where 7 is the number of days.
  
  Thanks for your support :)

  • 
  •  
•  
•  

Users on-line

• slam

This list is based on users active over the last 60 minutes.