php paging

[gesf]

Try something like:

<?php

$query = "SELECT * FROM friend WHERE age=" . $age . " AND sex='" . $seek . "' ORDER BY username LIMIT " . $offset1 . "," . $perpage;

// Or
$query = "SELECT * FROM friend WHERE age={$age} AND sex='{$seek}' ORDER BY username LIMIT {$offset1},{$perpage}";

?>