Go Back   CodingForums.com > :: Server side development > PHP
Reload this Page Choose which rows to display depending on date

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 07-02-2007, 09:22 PM   PM User | #1
Crazydog
Regular Coder

 
Join Date: May 2005
Posts: 224
Thanks: 1
Thanked 0 Times in 0 Posts
Crazydog is an unknown quantity at this point
Choose which rows to display depending on date
In my rows in my table, I have 3 separate columns storing the day, month, and year the columns were added

What's the best way to let someone choose a range of dates, and display the rows that are in that range?
Crazydog is offline   Reply With Quote
Old 07-02-2007, 09:28 PM   PM User | #2
devinemke
Regular Coder

 
devinemke's Avatar
 
Join Date: Dec 2004
Location: NYC
Posts: 443
Thanks: 0
Thanked 12 Times in 11 Posts
devinemke is an unknown quantity at this point
why are you storing your dates in 3 separate fields? just use 1 DATE field and use the BETWEEN clause to select a certain range.
devinemke is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:06 PM.
Advertisement
Log in to turn off these ads.