function getcolor(){
include "../../connect.php";
include "../../chksession.php";
$sql="select id from register where username='$sess_username'";
$result=mysql_db_query($dbname,$sql);
$r=mysql_fetch_array($result);
$id=$r[id];
$sql="select * from booking where Discount='' and id_user='$id'";
$result1=mysql_db_query($dbname,$sql);
$r1=mysql_fetch_array($result1);
$id_tour=$r1[id_tour];
$sql="select * from chair where id_program='$id_tour'";
$result2=mysql_db_query($dbname,$sql);
$r2=mysql_fetch_array($result2);
$chair=$r2[chair];
if($chair !=''){
$bg1='#0000ff';
return $bg1;
}
else
{
$bg1='#0000ff';
return $bg1;
}
}