[PHP3] search query From: AbsM (abs1 <email protected>)
Date: 02/21/00

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.
A dynamic scroll needed to keep track of total screens available.

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 <email protected>