min/max tables.

[SDeon]

Hi friends,
My database search table with min and max fields. The search form has fields for inputing min and max values. I wana find if any value within the range of the search min and max form is in between the values of the min. and max. fields from the database. I need to check for if min or max fits into range stored in database but dont know how to find if any value in the search range fits into the stored range?
Thanks for help in advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

hi,

Check if user's min is in range from database
Check if user's max is in range from database

If any of the above conditions are true then the criteria is met and if both are false then the criteria is not met. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --