All pastes #905168 Raw Edit

Anonymous

public php v1 · immutable
·published 2008-02-15 16:35 UTC
rendered paste body
//Lines 38 - 63$clause = array();if ($_GET['nb_author'] != "") {	$clause[] = "nb_auth LIKE '%$_GET[nb_author]%'";}if ($_GET['nb_subj'] != "") {	$clause[] = "nb_subject LIKE '%$_GET[nb_subj]%'";}if ($_GET['nb_num'] != "") {	$clause[] = "nb_number LIKE '%$_GET[nb_num]%'";}if ($_GET['nb_type'] != "") {	$clause[] = "nb_type LIKE '%$_GET[nb_type]%'";}$clause = implode(' AND ', $clause);// Grab the Results and Num count$sql = "SELECT * FROM Notebooks WHERE $clause ORDER BY nb_number ASC"; $result=mysql_query($sql, $db_link); $nb_result = mysql_num_rows($result);include('../_resources/PaginateIt.php');$PaginateIt = new PaginateIt();$PaginateIt->SetItemsPerPage(10);$PaginateIt->SetPaginationMode('Slide');$PaginateIt->SetItemCount($nb_result);// Create the Final Output for pagination$sql=mysql_query("SELECT * FROM Notebooks WHERE $clause ORDER BY nb_number ASC".$PaginateIt->GetMySqlLimit());// Lines 162 - 164echo '<div class="vbulletin">';echo $PaginateIt->GetPageLinks('<div class="page_summary">Page {c} of {t}:</div>{p:&lt;} {links:5: } {n:&gt;}');echo '</div>';// Line 175while ($result=mysql_fetch_assoc($sql)) {   My returning HTMLcode}