if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$start_from = ($page-1) * 20;
switch ($HTTP_GET_VARS['by']){
default:
case 'naam':
$sql = "SELECT * FROM upload2 ORDER BY naam ASC LIMIT $start_from, 20";
break;
case 'merk':
$sql = "SELECT * FROM upload2 ORDER BY merk ASC LIMIT $start_from, 20";
break;
case 'model':
$sql = "SELECT * FROM upload2 ORDER BY model ASC LIMIT $start_from, 20";
break;
}
$rs_result = mysql_query ($sql);
?>