Re: View all results between date 'a' and date 'b'

On Friday 05 September 2003 16:55, Tristan.Pretty@risk.sungard.com wrote: > Probably a simple query, but gogle has turned up good, but not specific > info... > > I have a data capture form, that I wanna view the results of. > All good, I've built a results page, that fitlers by many different > catagories etc... > what I'd like to do now, is have two date fields to sort by, and then only > get the entries that fall between those two dates... > I've used the mysql 'date' field on the field in the table I'm using... > > How can it be done...? mysql manual > date functions mysql manual > BETWEEN -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* Why does a hearse horse snicker, hauling a lawyer away? -- Carl Sandburg */