Why i cant call time that less then 6:00

Asked Jun 29 '18 at 02:22

Active Jun 29 '18 at 02:25

Viewed 40 times

I cant call the time that i want im using the sytext

$sql="select kedatangan.id,pelajar.nama,kedatangan.masa 
    from pelajar 
    join kedatangan on pelajar.barcode= kedatangan.barcode 
    where 'masa' <= "8:00" order by id;";

But it doesn't work as i want..but when i change this < to this > it can call but it call all the data without following this statment

edited Jun 29 '18 at 02:25

Barmar

741,623
53
500
612

asked Jun 29 '18 at 02:22

Lost Boy

2

You need to change the quotes around `masa` to backticks. – Barmar Jun 29 '18 at 02:24
I already change masa using backtick but it still give negative respond – Lost Boy Jun 29 '18 at 04:08
Can you show some sample table contents? What is the datatype of the `masa` column? – Barmar Jun 29 '18 at 15:16
You have another quoting problem. The double quotes around `8:00` will end the PHP string. You should be getting a PHP parse error from this. – Barmar Jun 29 '18 at 15:17
Either put single quotes around the whole string, or single quotes around `8:00`. – Barmar Jun 29 '18 at 15:17
thanks @barmar i already solve this problem – Lost Boy Jul 04 '18 at 15:35

Why i cant call time that less then 6:00

0 Answers0