Member Avatar for ismail.eyiowuawi

I have two textfields which are formatted for dates, i want to retrieve data from the database within a period of days which the two textfields stand for the "from" and "to" dates.Can anybody help me out?

select distinct courseId,courseName,description,Date,amount from course where date>='2013/05/11' and date<='2013/05/11'
for the SQL queries above, i used JDatepickers, the Jdatefield when editted to pick to pick the date, it does not change, when i echo the combination of the sql query, it shows current date.

  • 2 Contributors
  • 1 Reply
  • 279 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by stultuske
Member Avatar for stultuske

so ... what exactly did you expect? if the current (now yesterdays) date is in your db, that result is correct.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.