Code: Select all
$q = "select * from properties where propID > 1 && ";
if ($pClass1) {
$q .= "class = '$pClass1' ";
}
if ($pClass2) {
$q .= "|| class = '$pClass2'";
}
if ($pClass3) {
$q .= "|| class = '$pClass3'";
}
...
Moderator: General Moderators
Code: Select all
$q = "select * from properties where propID > 1 && ";
if ($pClass1) {
$q .= "class = '$pClass1' ";
}
if ($pClass2) {
$q .= "|| class = '$pClass2'";
}
if ($pClass3) {
$q .= "|| class = '$pClass3'";
}
...
Code: Select all
$options[] = $pClass1;
$options[] = $pClass2;
$options[] = $pClass3;
while($i = 0; $i < count($options); $i++)
{
if($i != 0)
$q .= " || ";
$q .= "class = '$options[$i]'";
}
Code: Select all
$q = "select * from properties where propID > 0 ";
if ($pClass1 || $pClass2 || $pClass3 || $pClass4 || $pClass5 || $pClass6) {
$class = array();
if ($pClass1) {
$class[] = $pClass1;
}
if ($pClass2) {
$class[] = $pClass2;
}
if ($pClass3) {
$class[] = $pClass3;
}
if ($pClass4) {
$class[] = $pClass4;
}
if ($pClass5) {
$class[] = $pClass5;
}
if ($pClass6) {
$class[] = $pClass6;
}
for ($i = 0; $i < count($class); $i++) {
if ($i) {
$q .= "|| ";
}
if (!$i) {
$q .= "&& ";
}
$q .= "class = '$class[$i]' ";
}
}
Code: Select all
$q=array();
$possibilities=100;
for($i=0; $i<$possibilities; $i++)
{
if(${"pClass$i"})
$q[]=" `class`= '".${"pClass$i"}."'";
}
$q=implode('OR', $q);