Forgive me but i am new ish myself...
You can set up your variables from values stored in [$POST] by joining more onto the query
I had a similar problem I think, and I built the query up from the following
PHP Code:
// The basic SELECT statement
$select = 'SELECT *';
$from = ' FROM clients;
$where = ' WHERE 1';
$bywhat = ' ORDER BY id';
$Query = @mysql_query($select . $from . $where . $bywhat);
if (!$Query) {
exit('<p>Error retrieving clients from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
I might be all day wrong but I think I get the gist of your problem.
Bookmarks