search query

Hi, could you please assist with this query? Using Mysql there is a table with various columns containing information, each with unique ID. One of the columns was uploaded with image filenames and the corresponding image copied to the server. How can i have the pages dynamically generated through a php3 interface to the database content, when a search is done?? There exists images, descriptions, Etc.. Need to control the layout. E.g Photos displayed to the left of the screen with an extract of the description next to each photo, Trimmed to maybe 15 words. Allow a maximum of 10 such records per screen. Provide as many screens as necessary to display all records. E.g. 100 records. This should display 10 records per screen for a total of 10 screens. Currently the html front end is as follows: <input type="checkbox" name="foto_name" value="" checked> Search queries are as below: $result = mysql_query ("SELECT * FROM test WHERE country_residence like '%' AND country_residence like '$country_residence' AND gender like '$gender' 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 height >'$min_height' AND height <'$max_height' AND weight >'$min_weight' AND weight <'$max_weight' AND foto_name like '%' "); Thankyou abs1@cableinet.co.uk