On 5/8/2005 5:33:46 PM, Richard Collyer (richard@xxxxxxxxxxxxxx) wrote: > Ryan A wrote: > > > Hi, > > > Sorry I know this is OT but I'm hoping someone will still help...it should > > be quite simple :-) > > I have a field in the database called "age" which is a DATE field. > > > > I also have a webform where the user can select between which ages he wants > > the records shown... > > eg: if he types 23,25 then I should get all results where > > age >=23 and age <=25 > > > > Thanks, > > Ryan > > > > > > > What are you wanting? An sql query or a form? Hey Richard, Thanks for replying. I have the form without a problem, I dont know how to format the SQL query... the birthdates in the DB are like this: 12-01-1979 05-03-7955 etc Thanks, Ryan -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php