Database search filter

[sabr]

Hi Sorry have not been active, my project got scraped

LBC, I think you may need to remove the initial code blocks and just have:

Code:

if($project == 1){

Code:

$project = '1';

Code:

}

Code:

if($volunteer == 1){

Code:

$volunteer = '1';

Code:

}

Then when it comes to returning the results you would have something like:

Code:

if(!empty($_POST)){

Code:

echo "<strong>Here's what we found under Volunteers...</strong><br>";

Code:

if(!empty($matches) && $volunteer == 1){

Code:

foreach ($matches as $m){

Code:

$foundQ = $db->query("SELECT * FROM users WHERE volunteer = 1 AND id = ?",($m));

Code:

$found = $foundQ->first();

Code:

echo '<a href="users/profile.php?id='.$found->id.'"'.'>'.$found->fname.' '.$found->lname.'</a><br>';

Code:

}

Code:

}else{

Code:

echo "Sorry. No users were found";

Code:

}

Code:

}

Code:

?>

Hopefully the syntax is correct and this returns the results you are after. If this works you can insert an elif for projects.