The form below is an example is what I need to do, The user has the option to filter data based off a select menu.
If the user doesn't "select" from each section of the menu, the "AND" of the statement gets placed where it causes errors.
Html Form Example
Code:
<form action="browse.php" method="POST" class="forms">
<select name="CatId" class="formSelect125" size="1">
<option value="All">All Categories</option>
<option value="1">Example One</option>
<option value="2">Example Two</option>
</select>
<select name="AuthorId" class="formSelect125" size="1">
<option value="All">All Authors</option>
<option value="1">Example One</option>
<option value="2">Example Two</option>
</select>
<select name="Difficulty" class="formSelect125" size="1">
<option value="All">All Difficulties</option>
<option value="1">Example One</option>
<option value="2">Example Two</option>
</select>
<input type="submit" class="formButtons" value="Filter">
</form>
As you can see from the above form the Url's would be sent as
browse.php?CatId=$CatId&AuthorId=$AuthorId&Difficulty=$Difficulty
If no menu was selected then the variable would be set to 'All'.
Example filter from CatId 1 only
browse.php?CatId=1&AuthorId=All&Difficulty=All
Now for the PHP...
PHP Code:
// Get the varibles
$CatId = (isset($_REQUEST['CatId'])) ? $_REQUEST['CatId'] : $CatId;
$AuthorId = (isset($_REQUEST['AuthorId'])) ? $_REQUEST['AuthorId'] : $AuthorId;
$Difficulty = (isset($_REQUEST['Difficulty'])) ? $_REQUEST['Difficulty'] : $Difficulty;
// If any variable is empty, then change to 'All',
if ($CatId == "")
$CatId = "All";
if ($AuthorId == "")
$AuthorId = "All";
if ($Difficulty == "")
$Difficulty = "All";
Ok, Here's where I' am getting confused, I need this to only set 'AND' if two or more selects have been made.
Build the query
PHP Code:
$Condition = "SELECT * FROM MyTable";
if (empty($CatId) OR $_GET["CatId"] == 'All')
{
} else {
$Where .= " CatId = '$CatId' AND ";
}
if (empty($AuthorId) OR $_GET["AuthorId"] == 'All')
{
} else {
$Where .= " AuthorId = '$AuthorId' AND ";
}
if (empty($Difficulty) OR $_GET["Difficulty"] == 'All')
{
} else {
$Where .= "Difficulty = $Difficulty ";
}
$Condition .= " WHERE " . $Where;
// Print the query
Print "$Condition";
Now, This is all fine, If the user selects all the options.
Example of all options selected
SELECT * FROM MyTable WHERE CatId = '1' AND AuthorId = '1' AND Level = 1
When the user only selects 2 options, it would then remove one, but the last option would leave the 'AND' which would cause an error. Like so...
SELECT * FROM MyTable WHERE CatId = '1' AND AuthorId = '1' AND
What can I do, so the user could select any option in any order and the 'Statement' would know where to place or remove the 'AND'. 
Dev Articles Community Forums Sponsor:
March 4th, 2005, 10:25 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
