Search listing..

Need assistance please; Require the html form to search a mysql table, for many different photos. The photo filenames have been uploaded into a column called photo_name. The image been copied to the server. Each photo has a unique id No. that auto_increments. The input name =foto_name which corresponds with the column in the table. The problem is i dont wish to specify a particular value. Whats needed is a listing of all filenames under the foto_name column, not just one filename. <input type="checkbox" name="foto_name" value=" " checked> $result = mysql_query ("SELECT * FROM test 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 current_date - period < '$past_ads' AND foto_name like '$foto_name'; Any corrections or suggestions for the php script??? much appreciated Thanks. abs1@cableinet.co.uk