Search options

Need assistance please; Require the html form to search mysql table for varing Nos of days. When this is typed manually to Mysql the Results for past 7 days appear: current_date - period < 00000008 Whats required is to get this query from html to mysql via php. Any corrections offered for the php script??? much appreciated abbs1@x-stream.co.uk **************************************************************************** * Html Form: Search For : <select name="past_ads"> <option value = 0>UnSelected <option value> Past 7 Days <option value> Past 14 Days <option value> Past 21 Days <option value> All Ads </SELECT> **************************************************************************** **** Php dealing with search options: if ($past_ads == "Past 7 Days, Past 14 Days, Past 21 Days, All Ads") {$past_ads = '%';} **************************************************************************** **** Query to mysql Table: $result = mysql_query ("SELECT * FROM prof WHERE country_residence like '%' AND country_residence like '$country_residence' AND (to_days(now())-to_days(dob))/365 >'$min_age' AND (to_days(now())-to_days(dob))/365 <'$max_age' AND past_ads like 'Past 7 Days'=current_date - period < 00000008 **************************************************************************** ******