I just whipped up a cool little feature for the shirt database. You'll now see an ebay link at the top of the page. When you click on this link, you will be forwarded to an ebay search site of the current band.

Suppose you are looking at all the Floorpunch shirts. Clicking the ebay logo at the top of the page will shoot you over to an immediate search for Floorpunch gear on ebay. Check out the results here. Now, go dig through those shirt pics and see if you have any luck with ebay.

Let me know what you think. If you guys are into this, maybe I'll try and add something similar to the swap pages. Peace!

Labels: feature

0 Comments

Keep up with HYE?

  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 Interviews added to the Interview Section: