\n"); // Let's echo this feed.. echo ''; echo ' '.$rssdesc.' http://www.aoleonthemartiangirl.com/video/ '.$siteurl.''; $t=$_GET['t']; mysql_connect($dbhost, $dbuser, $dbpass); mysql_select_db("$dbname"); $q1 = "SELECT * FROM `myvideos` WHERE apro='1' ORDER by $t DESC LIMIT $sqlretrieve"; $r1 = mysql_query($q1) or die(mysql_error()); while($row = mysql_fetch_array($r1)) { $qra2 = 'SELECT * FROM myvideosrates WHERE id LIKE "'.$row[video].'"'; $qra12 = mysql_query($qra2) or die($qra12.'
'.mysql_error()); $qra12 = mysql_fetch_array($qra12); $showdatea=date('j M, Y', $sxe1[dateadd]); $moratea = @number_format($qra12[total_value]/$qra12[total_votes],1); $flvsize = round($row[totalsize]/1048576, 1); $minutesi = intval(($row[dura] / 60) % 60); $mti = str_pad($minutesi, 1, "0", STR_PAD_LEFT). ':'; $secondsi = intval($row[dura] % 60); $mti .= str_pad($secondsi, 2, "0", STR_PAD_LEFT); $categorytext = ereg_replace("&", "&", $row['category']); echo ' http://www.aoleonthemartiangirl.com/video/video/&v='.$row['video'].' http://www.aoleonthemartiangirl.com/video/video/&v='.$row['video'].' Added by '.$row['user'].' in category: '.$categorytext.'
Size '.$flvsize.' MB
Duration: '.$mti.' min.
Rating: '.$moratea.' / 10]]>'; } // We've just outputted all the news items (ie database results) // Now to close the feed echo ''; ?>