Limit koymak

<?
$types = $_GET['type'];
$go->lists();?>

		<?while(list($id,$type,$title,,$date) = mysql_fetch_row($go->lists)) {?>
	<tr>
	
		<td><a href="<?=$title?><?=$id?>.html"><?=$title?></a></td>

	<?}?>

function lists(){
global $page,$types,$q;

if($q){
	$query = " WHERE title LIKE '%$q%'";
	$orderby = "ORDER BY title ASC";
}

if($types){
	$query = " WHERE type LIKE '%$types%'";
	$orderby = "ORDER BY id DESC";
}
if(!$types && !$q){
$query = "";
$orderby = "ORDER BY id DESC";
}
if(!$page){
	$page = 1;
} 
		$startfrom = ($page - 1) * $this->perpage;
		$this->lists = mysql_query("SELECT * FROM $this->mysqldtable $query $orderby LIMIT $startfrom,$this->perpage");

}

Haymac adlı üyeden alıntı:

$this->perpage i bul bunu editle

CREATE TABLE deneme (
	id int(9) NOT NULL auto_increment,
	tip char(255) NOT NULL,
	baslik char(255) NOT NULL,
	aad TEXT NOT NULL,
	dato char(16) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE id (id)
);

CREATE TABLE deneme (
	id int(9) NOT NULL auto_increment,
	tip char(255) NOT NULL,
	baslik char(255) NOT NULL,
	aad TEXT NOT NULL,
	dato char(16) NOT NULL,
	PRIMARY KEY (id),
	UNIQUE id (id)
);

$result = mysql_query("SELECT * FROM veritabani order by hits DESC limit 0,5");

DESC limit 0,5