Dynamic Queries

[Anon]

Hi,

I'm trying to create a dynamic query writer for the admin side of my website.

The administrator has to be able to select which table and fields they would like in their query (using select forms) and possibly specify some criteria on each field. It also has to have upto 15 possible fields that can be chosen in a single query.

My idea is to have 2 select options for each possible field, i.e a Table Name option and then a Field name option (which will be dynamically populated after the table has been chosen)

Any help on this would be greatly appreciated....

[Anon]

You are doing right.

Just think your html form as a sql creator. The challenge with your case is to create the sql.

On your php, make it very modular. If you have a form to select users by age, sex, and weight, just make your html form with theses 3 criteras in a select box.

Then, make your sql that way:

$sql = 'SELECT whatiwant FROM tableiwant WHERE (1 = 1)'

if ($HTTP_POST_VARS['age']) {
$sql .= ' AND (age BETWEEN ... AND ...)';
}
if ($HTTP_POST_VARS['sex']) {
$sql .= ' AND (sex = ...)';
}

I guess you see how to proceed.