Labels: interview

  Swap Lists: $newlyAddedSwap / $totalSwap
  Shirts: $newlyAddedShirts / $totalShirts
  By band(s):

END_HTML; $queryDisShirt = "SELECT distinct(band) from shirts where DATE_FORMAT('$minus7','%Y-%m-%d') <= DATE_FORMAT(stime, '%Y-%m-%d') order by stime DESC"; $resultDisShirt = mysql_query($queryDisShirt); $j=0; while(($rowDisShirt = mysql_fetch_row($resultDisShirt)) && $j<10){ $name = strtoupper($rowDisShirt[0]); echo "
• $name
\n"; $j++; } PHP?>

  Collections:

New User: $name\n"; } $minus7 = date("Y-m-d", mktime(0, 0, 0, date("m") , date("d")-7, date("Y"))); $query = "SELECT co.name from collection_owner co, collection_image ci where co.uid=ci.userid AND DATE_FORMAT('$minus7','%Y-%m-%d') <= DATE_FORMAT(ci.tdate, '%Y-%m-%d')"; $result = mysql_query($query); while($row = mysql_fetch_row($result)){ $name = $row[0]; echo "
• New Picture: $name
\n"; } PHP?>

The last 5 reviews added to the Review Section:

The last 5 Blogs added to the Interview Section: