paging error near 'DESC LIMIT 0, 16'
nogen der kan hjælpe med dette script ????include("../config.php");
// Antal poster.
$query = "SELECT * FROM user";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_assoc($result);
// Sætter side nr.
$side = (isset($_GET["side"])) ? $_GET["side"] : 0;
// Værdier til LIMIT
$row_count = 16; // Antal af posts pr. side
$offset = $side * $row_count;
$col = 4; // Antal søjler pr. side
$colCount = 1;
// Hoved query
$query = "SELECT * FROM user ORDER BY $username DESC LIMIT $offset, $row_count";
$result = mysql_query($query) or die(mysql_error());
echo "<TABLE cellSpacing=1 cellPadding=1 width=600 border=1>
<TBODY>
<TR STYLE=\"font-weight: Bold;\">
<TD CLASS=\"tdbg\">"._NICKNAME."</TD>
<TD CLASS=\"tdbg\"> </TD>
</TR>";
while ($row = mysql_fetch_assoc($result))
{
extract($row);
echo "<TR><TD type=\"text\"> $username </TD>
<TD CLASS=\"tdbg\">
<A HREF=\"../includes/user.php?action=activate&username=$username\" class=\""._SUSPEND."\"><IMG SRC=\"../images/inactive.gif \" ALT=\""._SUSPEND."\" title=\""._ACTIVATE."\"BORDER=\"0\"></A>
<A HREF=\"../includes/user.php?action=edit&username=$username\" class=\""._EDIT."\"><IMG SRC=\"../images/edit.gif\" ALT=\""._EDIT."\" title=\""._EDIT."\" BORDER=\"0\"></A>
<A HREF=\"../includes/user.php?action=delete&username=$username&setupby=$setupby&allowzones=$allowzones\" class=\""._DELETE."\"><IMG SRC=\"../images/delete.gif\" ALT=\""._DELETE."\" title=\""._DELETE."\" BORDER=\"0\"></A>
";
if ($colCount == $col)
{
$colCount = 0;
echo "</tr><tr>";
}
$colCount++;
}
echo "</tr></table>";
// Side rotering
if ($side > 0)
echo "<a href='listuser.php?side=" . ($side - 1) . "'><img src='images/leftpil.gif' border='0'></a>";
else
echo " ";
if ($total > $offset+$row_count)
echo "<a href='listuser.php?side=" . ($side + 1) . "'><img src='images/rightpil.gif' border='0'></a>";
?>
