What's new

Closed Mysqli selecting a same date in database

Status
Not open for further replies.

T_T Ellaaaa T_T

Eternal Poster
Joined
Jul 21, 2017
Posts
626
Reaction
447
Points
260
Code:
SELECT r_date FROM reservation WHERE r_date >= '2018-01-01' AND r_date <= '2018-12-31' AND r_date = r_date

Code:
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
 

Attachments

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'
 
Tama ung comments above sir .need mo ng condition sa WHERE. If wala kang condition na need,

SELECT * FROM tablename;
 
Status
Not open for further replies.

Similar threads

Back
Top