Casinos Search


Casinos Search
   Before going to search, please select the below category....
Casino Wise    City Wise      State Wise


$last) { $pagenum = $last; } $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; //echo $max; $result = mysql_query("SELECT * FROM `casinocity` WHERE Casino_club LIKE '%$search1%' $max"); $numrow=mysql_num_rows($result); if( $numrow != 0 ) { echo ''; echo ''; $i=1; echo ''; while ($city = mysql_fetch_array($result)) { $cityid = $city['ciid']; echo ''; echo ''; echo ''; } $i = $i+1; echo ''; echo '
Results for "'.$search1.'" casino clubs
'.$city['city'].''.$city['Casino_club'].'
'; echo "

"; echo " --Page $pagenum of $last--

"; if ($pagenum == 1) { } else { echo " <<-First "; echo " "; $previous = $pagenum-1; echo " <-Previous "; } echo " ---- "; if ($pagenum == $last) { } else { $next = $pagenum+1; echo " Next -> "; echo " "; echo " Last ->> "; } } else { $noresults="No Results Found . . ."; echo '

'; echo '

'.$noresults.'

'; echo '
'; } } elseif($ans=='city') { $result = mysql_query("SELECT * FROM `casinocity` WHERE city LIKE '%$search1%'"); $numrow=mysql_num_rows($result); if( $numrow != 0 ) { echo ''; echo ''; $i=1; echo ''; while ($city = mysql_fetch_array($result)) { $cityid = $city['ciid']; echo ''; echo ''; echo ''; } $i = $i+1; echo ''; echo '
Results for "'.$search1.'" casino clubs
'.$city['city'].''.$city['Casino_club'].'
'; } else { $noresults="No Results Found . . ."; echo '
'; echo '

'.$noresults.'

'; echo '
'; } } elseif($ans=='state') { $statequery=mysql_query("SELECT * FROM state WHERE state LIKE '%$search1%'"); $numrow=mysql_num_rows($statequery); if($numrow != 0 ) { while($state=mysql_fetch_array($statequery)) { $stid=$state['sid']; } $result = mysql_query("SELECT * FROM `casinocity` WHERE sid=$stid"); echo ''; echo ''; $i=1; echo ''; while ($city = mysql_fetch_array($result)) { $ciid = $city['ciid']; echo ''; echo ''; echo ''; } $i = $i+1; echo ''; echo '
Results for "'.$search1.'" casino clubs
'.$city['city'].''.$city['Casino_club'].'
'; } else { $noresults="No Results Found . . ."; echo '
'; echo '

'.$noresults.'

'; echo '
'; } } } } ?>
©2011 All Rights Reserved.www.bestcasinosreview.com.