'Y' ORDER BY RAND() LIMIT 10"; $result=$database->database_query($sql) or $em=$em.$database->database_error(); $sql2="SELECT count(`you_x_tube`.`id`) AS yid FROM `you_x_tube` WHERE `you_x_tube`.`youtube` = 'Y' AND `you_x_tube`.`vid_active` = 'Y' LIMIT 27 OFFSET 0"; $rcount=$database->database_query($sql2); $thecount = $database->database_result($rcount,0); $database->database_free_result($rcount); $sql3="SELECT `you_x_tube`.`id`, `you_x_tube`.`vid_id`, `you_x_tube`.`width`, `you_x_tube`.`height`, `you_x_tube`.`vid_desc`, `you_x_tube`.`vid_title` FROM `you_x_tube` WHERE `you_x_tube`.`ytfeatured` = 'Y' AND `you_x_tube`.`vid_active` = 'Y' LIMIT 1"; $result3=$database->database_query($sql3) or $em=$em.$database->database_error(); $rownum=0; $thetubes=""; $currentids=""; while($f = $database->database_fetch_assoc($result3)) { $ytimage="https://img.youtube.com/vi/".$f["vid_id"]."/0.jpg"; $ytvid="http://www.youtube.com/watch?v=".$f["vid_id"]; $thetubes=$thetubes."