search bar

jauson

Helo, I have a problem, I limit the records by department, for example in my page the records shows only the IT department, but when I search a name in search bar for example I will search a name of employee in other department their record will show. how do i limit the search bar by department only? thanks a lot.

$sWhere = "WHERE department='$department'";
if ( $_GET['sSearch'] != "" )
{
$sWhere = "WHERE (";
for ( $i=0 ; $i

allan

You need to add an AND condition to the WHERE after the column specific search has been built. Something like $sWhere .= " AND department='$department'"; - remember to add a condition for when $sWhere is empty though!

Allan

jauson

I don't know where do i need to input the ADD OPERATOR.. can u show me where?

$sWhere = "WHERE department='$department'";
if ( $_GET['sSearch'] != "" )
{
$sWhere = "WHERE (";
for ( $i=0 ; $i

allan

Rather than doing it at the start of that code block, do it at the end.

Allan