'.$adname1.'Click on picture to select video'.$adname1.''; $titlequery = "SELECT vid_id, vid_title, vid_description, folder_name, picture_name, file_name, hits FROM video_details ORDER BY hits DESC"; $titleresult = mysql_query($titlequery); $titlesfound = mysql_num_rows($titleresult); for ($n=1; $n<=$titlesfound; $n++) {$titlerow = mysql_fetch_row($titleresult); $vid_id = $titlerow[0]; $vid_title = $titlerow[1]; $vid_description = $titlerow[2]; $vid_folder = $titlerow[3]; $vid_picture= $titlerow[4]; $vid_file = $titlerow[5]; $vid_hits = $titlerow[6]; $filename = "/archive/".$vid_folder."/".$vid_file; $picname = "/archive/".$vid_folder."/".$vid_picture; echo '
'; echo 'Number '.$n.'

'.$vid_title.'

'.$vid_description.'
'.$vid_hits.' views

'; } echo ''; ?>