t;$tmpquery .= $filter2;
>$tmpquery .= " AND ";
>}
>
>$query=substr($tmpquery,0,strlen($tmpquery) - 4); // remove extra AND
>
>
>
>I haven't tried this with checkboxes, but you should get the idea. This
>works with other
>queries that I
($tmpquery) - 4); // remove extra AND
I haven't tried this with checkboxes, but you should get the idea. This
works with other
queries that I have done.
John Lodge
-Original Message-
From: Trelfa, Jonathon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 3:45 PM
To: SQL Mailing
I am attempting to generate a query statement (using PHP) that is generated
based on user input from 2 sets of checkboxes. You can see a
barely-functioning version at this URL:
http://www.nobleaccord.com/view/view.php
The top part of the form just shows what the query statement looks like.
The