0) && (floor($id) == $id); } if ($cat == '-' ) {$c =''; } else { $c = "AND cat = '$cat'" ; }; if (!$name) {$n ='';} else { $n =" AND name LIKE " . sqlesc("%$name%") ." " ; }; $query = "WHERE valid='1' $n $c "; print("

\n"); // error reporting needed $res = mysql_query("SELECT COUNT(*) FROM product $query order by id desc") or sqlerr(); $arr = mysql_fetch_row($res); $pages = floor($arr[0] / $perpage); if ($pages * $perpage < $arr[0]) ++$pages; if ($page < 1) $page = 1; else if ($page > $pages) $page = $pages; for ($i = 1; $i <= $pages; ++$i) if ($i == $page) $pagemenu .= "$i\n"; else $pagemenu .= "$i\n"; if ($page != 1) $browsemenu .= "<<< First "; if ($page == 1) $browsemenu .= "<<< First << Prev"; else $browsemenu .= "<< Prev"; $arnumb = $page * $perpage; if ($arnumb > $arr[0]) $arnumb = $arr[0] ; $browsemenu .= " Showing $arnumb of $arr[0] "; if ($page == $pages) $browsemenu .= "Next >> Last >>>"; else $browsemenu .= "Next >>"; if ($page != $pages) $browsemenu .= " Last >>>"; print("

$browsemenu
$pagemenu

"); $offset = ($page * $perpage) - $perpage; $res = mysql_query("SELECT * FROM product $query order by id desc LIMIT $offset,$perpage") or sqlerr(); $num = mysql_num_rows($res); // Date echo ""; (!is_valid_id($cat))? Print("") : ""; // Category echo""; ($cat >= 4)? Print("") : "" ; echo""; ($cat <= 3)? Print("") : "" ; // echo""; echo " "; for ($i = 0; $i < $num; ++$i) { $arr = mysql_fetch_assoc($res); $res2 = mysql_query("SELECT * FROM cat where id = $arr[cat]"); $arr2 = mysql_fetch_assoc($res2); // Date of the add echo " --> "; (!is_valid_id($cat))? Print("") : "" ; // Name for the product [type] echo""; ($cat >= 4)? Print("") : "" ; // The size of the CDs echo""; // ($cat <= 3)? Print("") : "" ; // echo""; echo " "; } echo "

Date	Category	Type	Name	cast	CDs	InfoBy	InfoBy
$arr[date]	$arr2[name]	$arr[type]	$arr[name]	$arr[cast]	$arr[cds]	$arr[rate]	$arr[downloader]

"; print("

$pagemenu
$browsemenu

"); include "l.inc.htm"; ?>