0) { ob_start(); $page = $_GET[p] ? $_GET[p] : 1; $limit = 50; $start = ($page - 1) * $limit; $slimit = "LIMIT ". $start . ", " . $limit; $resultt = mysql_query("SELECT * FROM schools WHERE LOWER(REPLACE(state, ' ', '')) = LOWER(REPLACE('$strState', ' ', ''))"); $total = mysql_num_rows($resultt); $pages = (int) ceil($total / $limit); if($pages == 0) $pages = 1; $result = mysql_query("SELECT * FROM schools WHERE LOWER(REPLACE(state, ' ', '')) = LOWER(REPLACE('$strState', ' ', '')) $slimit"); $result1 = mysql_query("SELECT state FROM schools WHERE LOWER(REPLACE(state, ' ', '')) = LOWER(REPLACE('$strState', ' ', '')) LIMIT 1"); if($item = mysql_fetch_assoc($result1)) { $strTitle = "Martial Art Schools in $item[state] - " . $cfgCompany; $strArticleHeader = "Martial Art Schools in $item[state]"; } if(mysql_num_rows($result) > 0) echo ""; if($pages > 1) { echo '

Displaying page '. $page . ' of ' . $pages . ' [ '; if($page > 1) echo '<< '; echo '1 '; for($i = 2; $i <= $pages; $i++) { if($page != $i) echo '' . $i . ' '; else echo '' . $i . ' '; } if($page < $pages) echo '>> '; echo ' ]

'; } $strArticleContent = ob_get_clean(); $states_temp = array(); foreach($states as $state) $states_temp[] = strtolower(str_replace(' ', '', $state)); if(!(mysql_num_rows($result) > 0) && array_search($strState, $states_temp) !== false) { $strTitle = "Martial Art Schools in " . ucwords($strState) . " - " . $cfgCompany; $strArticleHeader = "No Martial Art Schools Listed"; $strArticleContent = "

We do not have any martial art school listed from the state you have selected. Please contact us if you want us to have your listing included."; } else if(!(mysql_num_rows($result) > 0)) header("Location: " . PATH_CLIENT_MAIN); } else header("Location: " . PATH_CLIENT_MAIN); ?>