Search BloodBanks
Check Blood banks List
All Government Listed Blood Banks
List of all indian blood banks
-
////////////// $noi=mysql_fetch_array(mysql_query($db,"SELECT COUNT(DISTINCT state) FROM Banks WHERE state IS NOT NULL"));
$result = mysqli_query($db, "SELECT COUNT(DISTINCT state) FROM Banks WHERE state IS NOT NULL");
$totalart = mysqli_fetch_row($result)[0];
$num_items = $totalart; //changable
$items_per_page= 1000;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
//changable sql
$sql = "SELECT state, seo_state, COUNT(*) as notl FROM Banks WHERE state!='' GROUP BY State ORDER BY State ASC LIMIT $limit_start, $items_per_page";
$cou = $limit_start;
$items = mysqli_query($db, $sql);
echo mysqli_error();
if(mysqli_num_rows($items)>0)
{
while ($item = mysqli_fetch_array($items))
{
$cou++;
$lnk = "
- $item[2]$item[0] "; echo "$lnk"; } } ?>