'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."

Featured Video

 
".stripslashes($f['vid_title'])."
".stripslashes($f["vid_desc"])."
 
"; } /* while ($row = $database->database_fetch_assoc($result)) { if($currentids==""){$currentids=$row["id"];} else{$currentids=$currentids.",".$row["id"];} $rownum=$rownum+1; if($rownum % 2 != 0){$rc="#333";} else{$rc="#000";} $ytimage="https://img.youtube.com/vi/".$row["vid_id"]."/1.jpg"; $thetubes=$thetubes."
".stripslashes($row['vid_title'])."
".stripslashes($row["vid_desc"])."
 
"; } $thetubes=$thetubes." ";*/ $limit=300; $container="thetubes"; $page_url="/js/act/get_youtube.php"; $navaid=recordsetNav($thecount,$page_url,$container,$offset,$limit,0); $navaid="
".$navaid."
"; $thetubes=$thetubes.$navaid; $arr = array ('error'=>$em, 'thecontent'=>$thetubes); echo json_encode($arr); ?>