Kenny_Luck

I now had mostly figure out and able to run it and use it , thank you for all your help specially Barand thanks

if i change if($sql == 0) is still the same the value wont come out

Im so confuse right now

So this mean that this code is completely useless and i cant get the Conflicts value at all

I using mysqli , the code that i posted is the one i write , so you are basically saying that my query for is not run right

Im just learning the double prevention which im going to do for my assignment

i dont quiet understand what you are trying to say

$sql="SELECT COUNT(*) as conflicts FROM rental WHERE plateNum = $plateNum AND Dispatch > $Dropoff AND Dropoff > $Dispatch"; if("0"){ $sql="INSERT INTO rental (Rentdate,Dispatch,Dropoff,Dis_TIME,Drop_TIME,Ins,Tcost,PDcost,plateNum,userID)VALUES(CURDATE(),'$Dispatch','$Dropoff','$Dis_TIME','$Drop_TIME','$Ins','$Tcost','$PDcost','$plateNum','$userID')"; $result=$conn->query($sql); }else{ echo"Fail";} how do I get the value of the conflicts im now very clueless

i see thanks , if i got any problem i will ask it , thanks for your help

so if i wan to like rent the car starting with 11/8/2018 is still possible right ??

I am facing a problem with double booking , i don't know where to start to write the code that a customer can't rental the same car at for the same day. For example, if a customer choose to book car A from 1/8/2018 till 10/8/2018 , how do i avoid that other customer won't book on the date 1/8/2018 or even 2/8/2018 and so on. Pls help me is quiet urgent