Video Out

" . mysql_error(); } $numrows = 0; $ids = ""; while($fetch_row = mysql_fetch_assoc($resultCount)) { $cat_array = explode(',', $fetch_row['categories']); $final_array = array_diff($category_values_compare, $cat_array); if(empty($final_array)) { $ids .= $fetch_row['nid'] . ", "; $numrows++; } } $ids = trim($ids, ", "); //if there is no results if($numrows != 0) { ///////////////////////////////////////// ////// Prevent Injection Attack ///////// ////// Set $pageno variable ///////////// ///////////////////////////////////////// if(isset($_GET['pageno'])){ if(!is_numeric($_GET['pageno'])){ print 'Error.'; exit(); } $pageno = $_GET['pageno']; } else { $pageno = 1; } $perPage = 20; $lastpage = ceil($numrows/$perPage); $pageno = (int)$pageno; if($pageno < 1){ $pageno = 1; }elseif($pageno > $lastpage){ $pageno = $lastpage; } // ----- PAGE LINKS ----- if($pageno == 1){ $pages .= 'FIRST | PREVIOUS '; } else { $pages .= "FIRST | "; $prevpage = $pageno - 1; $pages .= " PREVIOUS "; } $pages .= ' ( Page '.$pageno.' of '.$lastpage.' ) '; if($pageno == $lastpage){ $pages .= ' NEXT | LAST '; } else { $nextpage = $pageno + 1; $pages .= " NEXT | "; $pages .= " LAST"; } $query2 = "SELECT content_type_video.nid AS node_id, title, field_video_artist_value, field_date_value, field_video_country_value, field_field_accession_number_value FROM content_type_video, node WHERE content_type_video.nid IN (" . $ids . ") AND content_type_video.nid = node.nid"; $limit = ' LIMIT ' . ($pageno - 1) * $perPage . ', ' . $perPage; $query2 = $query2.$limit; $result = mysql_query($query2); if(!$result){ echo 'Query failed: ' . mysql_error(); } $intCount = 0; while($strRow = mysql_fetch_assoc($result)){ $strStripe = $intCount % 2 ? 'even' : 'odd'; print ""; print ""; print ""; print ""; print ""; print ""; print ""; $intCount++; } } } print "

"; print $strRow['title']; print "

"; print $strRow['field_video_artist_value']; print "

"; print substr($strRow['field_date_value'], 0, 4); print "

"; print $strRow['field_video_country_value']; print "

"; print $strRow['field_field_accession_number_value']; print "

' . $pages . '