🔒 Closed Mysqli selecting a same date in database

[T_T Ellaaaa T_T]

SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31' AND r_date = r_date

SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31' AND r_date = r_date

Try ko na tong dalwang query kaso yung result hndi equal yung nilalabas. Lahat ng laman yung nilalabas.

Please help for thesis purpose

 

[Game_Guardian18]

the last r_date on your query should be a value .. like 2018-09-26 ..

 

[fazz12]

kung yung nasa range lang ng between yung kailangan mo, tanggalin mo yung AND r_date=r_date.

SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31'

kung gusto mo namang saktuhang isang date lang ang lalabas,

SELECT r_date FROM reservation WHERE r_date = '2018-01-01'

 

[sephambo]

Tama ung comments above sir .need mo ng condition sa WHERE. If wala kang condition na need,

SELECT * FROM tablename;