I would like to see a professional mysql-query including sort, prev, next, alternating row colors and so on.
I wrote a query with each of those features,
but bringing them together makes problems
I include a piece of working code that i would like to get paged.
Maybe someone can help!
Thanks for viewing anyway!
<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");
$strSelectusedgames="select name,system,genre,umfang,fsk,preis,art from usedgames";
if (!empty($sort)) {
switch ($sort) {
case "name": $strSelectusedgames.=" order by name"; break;
case "system": $strSelectusedgames.=" order by system"; break;
case "genre": $strSelectusedgames.=" order by genre"; break;
case "umfang": $strSelectusedgames.=" order by umfang"; break;
case "fsk": $strSelectusedgames.=" order by fsk"; break;
case "preis": $strSelectusedgames.=" order by preis"; break;
case "art": $strSelectusedgames.=" order by art"; break;
}
}
$rsusedgames=mysql_query($strSelectusedgames);
$nRecusedgames=mysql_num_rows($rsusedgames);
$nLineusedgames=0;
if ($nRecusedgames>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 ($nLineusedgames<$nRecusedgames) {
$fieldname=mysql_result($rsusedgames,$nLineusedgames,"name");
$fieldsystem=mysql_result($rsusedgames,$nLineusedgames,"system");
$fieldgenre=mysql_result($rsusedgames,$nLineusedgames,"genre");
$fieldumfang=mysql_result($rsusedgames,$nLineusedgames,"umfang");
$fieldfsk=mysql_result($rsusedgames,$nLineusedgames,"fsk");
$fieldpreis=mysql_result($rsusedgames,$nLineusedgames,"preis");
$fieldart=mysql_result($rsusedgames,$nLineusedgames,"art");
$odd++; if ($odd==3) { $odd=1; }
if ($odd==1) { print "<tr>"; } else { print "<tr bgcolor=#08554F>"; }
if ((!empty($edit)) && (!empty($name)) && ($fieldname==$name)) {
print "<form action=\"ugview.php\"><input type=hidden name=sort value=\"$sort\">";
print "<td>Modif</td>";
print "<td><input type=text name=fieldsystem size= value=\"$fieldsystem\"></td>";
print "<td><input type=text name=fieldgenre size= value=\"$fieldgenre\"></td>";
print "<td><input type=text name=fieldumfang size= value=\"$fieldumfang\"></td>";
print "<td><input type=text name=fieldfsk size= value=\"$fieldfsk\"></td>";
print "<td><input type=text name=fieldpreis size= value=\"$fieldpreis\"></td>";
print "<td><input type=text name=fieldart size= value=\"$fieldart\"></td>";
print "<td><input type=submit value=\"OK\"></td>";
print "</form>";
} else {
print "<td><a href=\"order.php?name=$fieldname&system=$fieldsystem&genre=$fieldgenre&umfang=$fieldumfang&fsk=$fieldfsk&preis=$fieldpreis&art=$fieldart\">$fieldname</a></td>";
if ($fieldsystem=="") { $fieldsystem=" "; }
print "<td>$fieldsystem</td>";
if ($fieldgenre=="") { $fieldgenre=" "; }
print "<td>$fieldgenre</td>";
if ($fieldumfang=="") { $fieldumfang=" "; }
print "<td>$fieldumfang</td>";
if ($fieldfsk=="") { $fieldfsk=" "; }
print "<td>$fieldfsk</td>";
if ($fieldpreis=="") { $fieldpreis=" "; }
print "<td>$fieldpreis</td>";
if ($fieldart=="") { $fieldart=" "; }
print "<td>$fieldart</td>";
}
print "</tr>\r\n";
$nLineusedgames=$nLineusedgames+1;
}
print "</table>";
}
print "Anzahl: $nRecusedgames";
mysql_close();
?>
emails welcome!
