“; echo ”
“; echo ” “; echo ”
“; // display data in table// echo “
“;// echo ”|
“;// loop through results of database query, displaying them in the table for ($i = $start; $i “; $vid_cat = “”; if(mysql_result($result, $i, ‘LinkLocation’)==”D”) { $vid_cat = “Drama”; }elseif(mysql_result($result, $i, ‘LinkLocation’)==”RO”){ $vid_cat = “Romance”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”Y”){ $vid_cat = “Yoruba”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”C”){ $vid_cat = “Comedy”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”FF”){ $vid_cat = “Francophone”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”R”){ $vid_cat = “Religious”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”UM”){ $vid_cat = “Members”;}elseif(mysql_result($result, $i, ‘LinkLocation’)==”M”){ $vid_cat = “Musical”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”F”){ $vid_cat = “Fun”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”S”){ $vid_cat = “Sports”;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”T”){ $vid_cat = “Twi”;}$statp = “”;if(mysql_result($result, $i, ‘display’)==”k”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”G”){ $statp = “adHG.asp”;} elseif(mysql_result($result, $i, ‘display’)==”Z”){ $statp = “adE.asp”;} elseif(mysql_result($result, $i, ‘display’)==”F”){ $statp = “adHF.asp”;} elseif(mysql_result($result, $i, ‘display’)==”N”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”P”){ $statp = “premiumvideo/ad11.asp”;} elseif(mysql_result($result, $i, ‘display’)==”L”){ $statp = “adHL.asp”;} elseif(mysql_result($result, $i, ‘display’)==”M”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”F”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”Y”){ $statp = “adHKY.asp”;} elseif(mysql_result($result, $i, ‘display’)==”T”){ $statp = “adHK.asp”;} $cur_vid_title = mysql_result($result, $i, ‘LinkName’); if(strlen($cur_vid_title) > 25){ $cur_vid_title = substr($cur_vid_title,0,25).”…”; } $vid_cat2 = “”; if(mysql_result($result, $i, ‘LinkLocation’)==”D”) { $vid_cat2 = “Drama“; }elseif(mysql_result($result, $i, ‘LinkLocation’)==”RO”){ $vid_cat2 = “Romance“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”Y”){ $vid_cat2 = “Yoruba“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”C”){ $vid_cat2 = “Comedy“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”FF”){ $vid_cat2 = “Francophone“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”R”){ $vid_cat2 = “Religious“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”UM”){ $vid_cat2 = “Members”;}elseif(mysql_result($result, $i, ‘LinkLocation’)==”M”){ $vid_cat2 = “Musical“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”F”){ $vid_cat2 = “Fun“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”S”){ $vid_cat2 = “Sports“;} elseif(mysql_result($result, $i, ‘LinkLocation’)==”T”){ $vid_cat2 = “Twi“;}$statp = “”;if(mysql_result($result, $i, ‘display’)==”k”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”G”){ $statp = “adHG.asp”;} elseif(mysql_result($result, $i, ‘display’)==”Z”){ $statp = “adE.asp”;} elseif(mysql_result($result, $i, ‘display’)==”F”){ $statp = “adHF.asp”;} elseif(mysql_result($result, $i, ‘display’)==”N”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”P”){ $statp = “premiumvideo/ad11.asp”;} elseif(mysql_result($result, $i, ‘display’)==”L”){ $statp = “adHL.asp”;} elseif(mysql_result($result, $i, ‘display’)==”M”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”F”){ $statp = “adHK.asp”;} elseif(mysql_result($result, $i, ‘display’)==”Y”){ $statp = “adHKY.asp”;} elseif(mysql_result($result, $i, ‘display’)==”T”){ $statp = “adHK.asp”;} $cur_vid_title = mysql_result($result, $i, ‘LinkName’); if(strlen($cur_vid_title) > 25){ $cur_vid_title = substr($cur_vid_title,0,25).”…”; } echo ” “; echo ” ” .$cur_vid_title .”
“.$vid_cat2 .” “.mysql_result($result, $i, ‘hits’).” “; echo ” “;}// close table>// echo ”
.