how to ignore records for the content?

lawnder00

I have a table of users on my system with a column of profile id ranging from 1 to 5.

What I need is to ignore the id number '5' and don't display these records

Does anyone know if this is even possible?

ignignokt

Are you using server-side? Static HTML? Why does your table contain data that you do not want to use?

lawnder00

yes im using server side, and i'm going to use them, but I do not want display them
you know how I can do that?

ignignokt

The easiest way would probably be adding this:

$('#example').DataTable({
    "fnCreatedRow": function( nRow, aData, iDataIndex ) {
        if(aData['id'] == 5){
            $(nRow).addClass('hideme');
        }
    }
});

.hideme{
    display:none;
}

lawnder00

Thanks!!
but the point is that the record is still there hidden.

I found another solution adding these lines to the "simple" funcion of _ssp.php script

if ($where == "") { $where = "WHERE"; } else { $where .= " AND"; } $where .= " `profile_id` != 5";

I apologize for my poor english, i am learning

Lawnder

ignignokt

Ah, that is what I was asking in my first post. What you really want is to not have the data there at all, meaning you should not even be loading it which is what you are now doing in the query. :)