Ok, I need a little help. First, let me say that im definetly more of a design guy. However I do know a little bit of mysql/php. Im working on a project for my company. Basically we perform audits on our employees and from every audit there comes a few things. A name, the managers name, the date, the score, and the case type. My job is to setup a database were we can store all of this information and sort by various fields. I can set everything up but im having a problem with sorting by date. I am not sure the best way of going about setting this up. At first I thought about setting the date up individually such as day, month, and year. However if they wanted to sort from 09/23/05 - 10/23/05 I wouldnt be sure of how to do that. Im sorry if this doesnt make any sense, I have been at work on this nonstop and I cannot figure out the solution. Any ideas? Thanks.