•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 455,991 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,771 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 1263 | Replies: 7 | Solved
 |
•
•
Join Date: Nov 2007
Posts: 99
Reputation: 
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
hi
i have a table where dates and other info are getting inserted...
i have a form where the user can select a start date end date..
based on the start date and end date ..i want to retrieve all the content stored between these dates.....
i have a table where dates and other info are getting inserted...
i have a form where the user can select a start date end date..
based on the start date and end date ..i want to retrieve all the content stored between these dates.....
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
$sql="select * from table where (start_date between '$start_date' and '$end_date') or (end_date between '$start_date' and '$end_date')";
considering start_date and end_date are the columns of your table, the first condition will fetch the records if the start_date lies between the range of $start_date and $end_date (the user's input). similarly, it checks if end_date lies between the range.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Posts: 99
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
hi
i am doing attendance sheet..
wen the admin wants to check the attendance between two date then he will give the start and end date...
in the table there is one column for date...the table contain the user id(varchar) ,date(date),time(varchar)
i am doing attendance sheet..
wen the admin wants to check the attendance between two date then he will give the start and end date...
in the table there is one column for date...the table contain the user id(varchar) ,date(date),time(varchar)
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
how does the admin enter the dates? does he have a form ? what is the name of those text fields ? basically, this will work.
$start_date and $end_date are post variables of the form.
$sql="select * from table where date between '$start_date' and '$end_date'";
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Posts: 99
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
ya he is having a form the field names are day1 day2........the code tat u have sent id working....how to sort using single column un table
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
using order by clause.
order by date asc | desc
order by date asc | desc
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Nov 2007
Posts: 99
Reputation:
Rep Power: 1
Solved Threads: 2
Junior Poster in Training
thanks its working
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
you are welcome!
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- HOWTO: Run a Query on a Database using ODBC and return all Results into a DGV Object (C#)
- Selecting MYSQL into fields (HTML and CSS)
- pagination of mysql query results (PHP)
- DataBase Monitoring Script (Shell Scripting)
- Terrible Error while using MySQL resources (PHP)
- Php code confusion. Not sure how to describe (PHP)
- Please help me out with MySQL query (MySQL)
- Query Problem (MySQL)
- DB-Authentication php/mysql on Mac OSX v3 (PHP)
Other Threads in the PHP Forum
- Previous Thread: Looking for php/mysql tutor 10USD/hour
- Next Thread: Web Address For Free Downloading Of Pdf Copy Of A Php Book
