check court availability - PHP

salam..sy nk mintak tlg sgt2.sgt...next week dh nk kene present system.plz...

masalah sy, mcamana nk check court availability (gelanggang sukan). sy ada table booking. tiap kali sblm user nk booking court, die mesti check samada court tu ksong or tak pada tarikh n masa tertentu.



ni interface utk check availability tu.

paling susah skali nk match kan date and time. sebab date bole sama, tapi masa tak bole sama. so bile user submit, system akan check then kalo court tu kosong pd date and time tu, kuar mesej gtau yg court available dan user bole booking.

tolong sgt2 sape2 yg master php.sy dh nk putus asa dh.

Mana table schema? Tunjukkan table schema.

bab ni yg saya nak settle...sorry ye damia..ni die punye SQL statement lebih kurang..tapi ade ckit bugs lagi....awak boleh tolong tengokkan bugs die..sorry yek bz sangat...

SQL ni untuk cek sama ada Court tu dah booking ke belum..Kalau xde $theCount == 0 maknanye boleh book untuk tarikh yg dipilih...

Code:



$sql=sprintf("SELECT COUNT(*) AS theCount FROM userbooking WHERE book_date='".$DateBook."' and start_time BETWEEN '".$Time1."' AND '".$Time2."' and end_time BETWEEN '".$Time1."' AND '".$Time2."'");
$con= mysql_query($sql) or die(mysql_error());
$theCount= mysql_result($con, 0, 'theCount');

if( $theCount == 0 )
{
echo "Tiada Data";
         
//      $result=mysql_fetch_array(mysql_query("SELECT * FROM userbooking WHERE book_date='$DateBook' and Negara ='$Negara'"));


//$sql= "INSERT INTO userbooking(first_user_name, book_date, start_time , end_time, fut_court_id,Approval) VALUES('$Name', '$DateBook', '$Time1', '$Time2', '$CourtID','0')";
//     $con= mysql_query($sql) or die(mysql_error());

}



Sama2 la main dengan daun keladi...nanti gatal xtau...hahahaha

Ni Create Table SQL die:

Code:


 CREATE  TABLE  `futsal`.`Userbooking` (  `No` double NOT  NULL  auto_increment ,
 `first_user_name` varchar( 20  )  NOT  NULL default  '',
 `last_user_name` varchar( 20  )  NOT  NULL default  '',
 `matrix_no` varchar( 20  )  NOT  NULL default  '',
 `fac_dep` varchar( 50  )  NOT  NULL default  '',
 `phone_no` varchar( 20  )  NOT  NULL default  '',
 `email` varchar( 40  )  NOT  NULL default  '',
 `name_event` varchar( 50  )  NOT  NULL default  '',
 `book_date` date NOT  NULL default  '0000-00-00',
 `start_time` time NOT  NULL default  '00:00:00',
 `end_time` time NOT  NULL default  '00:00:00',
 `fut_court_type` varchar( 20  )  NOT  NULL default  '',
 `fut_court_id` varchar( 20  )  NOT  NULL ,
 `Approval` double NOT  NULL ,
 PRIMARY  KEY (  `No`  )  ) ENGINE  =  MyISAM  DEFAULT CHARSET  = latin1;