time.php~

<?php


include_once("config.lib.php");
$var = date("H:i");
//echo $var;


$sql="SELECT * 
FROM  `timecheck` 
WHERE DATE =  '2015-02-11'
AND TIME < '$var'
ORDER BY TIME DESC 
LIMIT 1";

$result=mysqli_query($conn,$sql);

$row=mysqli_fetch_array($result);
$sno=$row['sno'];


$sql= "SELECT * FROM `customerdemandseen` WHERE sno=1";

$result=mysqli_query($conn,$sql);
$row=mysqli_fetch_array($result);

$x=$sno;


//echo $row[$seen];

$flag=0;

while($x>0)
{
	//echo $x; $x=$x-1;
$seen="r".$x;


if($row[$seen]==0)
{$x=$x-1;}
else {$flag=1;break;}

}


echo $x+1;
?>