Now Playing: Command & Conquer Red Alert 3 - $ttitle
Top Command & Conquer Red Alert 3 Trailers
"; echo "";
$gId=123;
$qt = "SELECT trailer.trailerId,trailer.title,summary,trailer.link,trailer.image,DATE_FORMAT(timestamp, '%d %b %Y'),count, games.title FROM trailer, games WHERE trailer.gameId=$gId and games.gameId=$gId ORDER BY count desc Limit 3";
$rt = mysql_query($qt);
$j = mysql_num_rows($rt);
$i=0;
while($rowt = mysql_fetch_array($rt,MYSQL_NUM)) {
$i++;
$tId = $rowt[0];
$ttitle = $rowt[1];
$tsum = $rowt[2];
$tlink = $rowt[3];
$timg = $rowt[4];
$tdate = $rowt[5];
$title = $rowt[7];
$tct = preg_replace('/(?<=\d)(?=(\d\d\d)+$)/', ',', $rowt[6]);
if ($i==$j)
echo "
- ";
else
echo "
- $ttitle "; if ($timg == "") echo "
";
else
echo "- Posted: $tdate "; echo "
- $tsum "; echo "
- Watch Now! » "; echo "
- Views: $tct "; echo "
- ";
echo "
