Need To Change This Script...

[dpiearcy]

I have this pagination script that works well for my regular posts. But I want to paginate from the same database all the fields where a tinyint is 1 and not 0. So select all where "answered=1" in other words.

 

Here is the query which only selects my total num rows.

 

Can this be modified or should I just do a completely different query? A normal one?

 

Here's the query:

 

function pagination($query, $per_page = 10,$page = 1, $url = '?'){        
    $query = "SELECT COUNT(*) as `num` FROM {$query}";
    $row = mysql_fetch_array(mysql_query($query));
    $total = $row['num'];
       $adjacents = "2"; 

 

Since I don't want ALL rows just the rows where answered=1 can I change this or start from scratch?

 

Or, if you have a great easy pagination script you don't mind tossing my way that would be awesome too! ;-)

[Barand]

$query = "SELECT COUNT(*) as `num` FROM {$query} WHERE answered = 1";

[dpiearcy]

$query = "SELECT COUNT(*) as `num` FROM {$query} WHERE answered = 1";

 

Thanks Barand. That did the trick. You're quickly becoming my favorite on here since you seem to always be quick to answer my stupid questions :-)