query("select c.catname,p.recommended from category c inner join products p on p.categoryid=c.id and p.id=".intval($_GET['pid'])." limit 0,1");
$nm1=$nm->num_rows;
?>
Recommended by
query("SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}");
while ($row = $query->fetch_array()) {
?>