This piece of code works fine, but how do i get it paged (15 records at the time) ?
Could please somebody help???
<head>
<title>----</title>
<link rel="stylesheet" href="my.css" type="text/css">
</head>
<?
mysql_connect("localhost","---","---") or die ("DBMS Server Error");
mysql_select_db("---") or die ("DBMS Database Error");
$strSelect="select name,system,genre,umfang,fsk,preis,art from usedgames";
if (!empty($sort)) {
switch ($sort) {
case "name": $strSelect.=" order by name"; break;
case "system": $strSelect.=" order by system"; break;
case "genre": $strSelect.=" order by genre"; break;
case "umfang": $strSelect.=" order by umfang"; break;
case "fsk": $strSelect.=" order by fsk"; break;
case "preis": $strSelect.=" order by preis"; break;
case "art": $strSelect.=" order by art"; break;
}
}
$rs=mysql_query($strSelect);
$nRec=mysql_num_rows($rs);
$nLine=0;
if ($nRec>0) {
print "<CENTER><table border=0><tr bgcolor=#009DC1><td><a href=\"$PHP_SELF?sort=name\">Name</a></td><td><a href=\"$PHP_SELF?sort=system\">System</a></td><td><a href=\"$PHP_SELF?sort=genre\">Genre</a></td><td><a href=\"$PHP_SELF?sort=umfang\">Umfg</a></td><td><a href=\"$PHP_SELF?sort=fsk\">FSK</a></td><td><a href=\"$PHP_SELF?sort=preis\">Preis €</a></td><td><a href=\"$PHP_SELF?sort=art\">NEU</a></td></tr>\r\n";
$odd=1;
while ($nLine<$nRec) {
$name=mysql_result($rs,$nLine,"name");
$system=mysql_result($rs,$nLine,"system");
$genre=mysql_result($rs,$nLine,"genre");
$umfang=mysql_result($rs,$nLine,"umfang");
$fsk=mysql_result($rs,$nLine,"fsk");
$preis=mysql_result($rs,$nLine,"preis");
$art=mysql_result($rs,$nLine,"art");
$odd++; if ($odd==3) { $odd=1; }
if ($odd==1) { print "<tr>"; } else { print "<tr bgcolor=#08554F>"; }
if ((!empty($edit)) && (!empty($name)) && ($name==$name)) {
print "<form action=\"$PHP_SELF?\"><input type=hidden name=sort value=\"$sort\">";
print "<td>Modif</td>";
print "<td><input type=text name=system size= value=\"$system\"></td>";
print "<td><input type=text name=genre size= value=\"$genre\"></td>";
print "<td><input type=text name=umfang size= value=\"$umfang\"></td>";
print "<td><input type=text name=fsk size= value=\"$fsk\"></td>";
print "<td><input type=text name=preis size= value=\"$preis\"></td>";
print "<td><input type=text name=art size= value=\"$art\"></td>";
print "<td><input type=submit value=\"OK\"></td>";
print "</form>";
} else {
print "<td><a href=\"order.php?name=$name&system=$system&genre=$genre&umfang=$umfang&fsk=$fsk&preis=$preis&art=$art\">$name</a></td>";
if ($system=="") { $system=" "; }
print "<td>$system</td>";
if ($genre=="") { $genre=" "; }
print "<td>$genre</td>";
if ($umfang=="") { $umfang=" "; }
print "<td>$umfang</td>";
if ($fsk=="") { $fsk=" "; }
print "<td>$fsk</td>";
if ($preis=="") { $preis=" "; }
print "<td>$preis</td>";
if ($art=="") { $art=" "; }
print "<td>$art</td>";
}
print "</tr>\r\n";
$nLine=$nLine+1;
}
print "</table>";
}
print "Anzahl: $nRec";
mysql_close();
?>
Thank you all!
