🔒 Closed Mysqli selecting a same date in database

Status
Not open for further replies.

T_T Ellaaaa T_T

Eternal Poster
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

  • 2.PNG
    2.PNG
    11.2 KB · Views: 0
  • 3.PNG
    3.PNG
    10 KB · Views: 0
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.

About this Thread

  • 3
    Replies
  • 681
    Views
  • 4
    Participants
Last reply from:
sephambo

Online now

Members online
891
Guests online
717
Total visitors
1,608

Forum statistics

Threads
2,275,563
Posts
28,964,107
Members
1,231,866
Latest member
terrorspeed
Back
Top