Need help with php and mysql pageing

1

i want to make a table with 3 colums an two lines, wich contains dynamicly loaded content, and it has a paging’system’( Prev 1 2 3 Next)
i ve tried it several times but wont get it working, it loads every time only 6 items(per mysql-limit)


<html>
<head>
<script type="text/javascript">
<!--
function send(pa,or)
{
   document.g.pa.value = pa;
   document.g.submit();
}
</script>
</head>
<?php
define(DB_host,'localhost');
define(DB_user,'root');
define(DB_password,'');
define(DB,'articipate');
$dbcon = mysql_connect(DB_host,DB_user,DB_password)or die(error);
$db = mysql_select_db(DB,$dbcon) or die(error);
$limit = 6;
$query_count = "SELECT titel FROM upload";
$result_count = mysql_query($query_count);
$total_rows = mysql_num_rows($result_count);

if (isset($pa))
 {
$page = $pa;
}
if(empty($page))
{
$page = "1";
}
$limit_value = $page * $limit - ($limit);
$query = "SELECT * FROM upload ORDER BY $orde LIMIT $limit_value, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
if(mysql_num_rows($result) == 0)
{
echo("Nothing to Display!");
}
$bgcolor = "#E0E0E0"; // light gray
echo"<form name='g' action='gallery.php' method='post'>";
echo"<input name='pa' type='hidden'>";
echo("<table><tr>");
while($row = mysql_fetch_array($result))
{
if ($bgcolor == "#E0E0E0")
{
$bgcolor = "#FFFFFF";
}
else
{
$bgcolor = "#E0E0E0";
}
echo("<td bgcolor=".$bgcolor.">");
echo($row["titel"]);
echo("</td>");
}
echo("</table>");
if($page != 1)
{
$pageprev = $page -1;
//echo("<a href='{$_SERVER['PHP_SELF']}?page=$pageprev'>PREV'.'$limit'.'</a>'");
//echo("<a href='$PHP_SELF?page=$pageprev'>PREV".$limit."</a> ");
echo("&nbsp;<b><a href='javascript:send($pageprev);'>prev</a></b>&nbsp;"); ///
}
else if($page = 1)
{
echo("&nbsp;prev&nbsp;");
}
$num_of_pages = $total_rows / $limit;
for($i = 1; $i <= $num_of_pages; $i++)
{
if($i == $page)
{
echo($i." ");
}
else
{
echo("&nbsp;<b><a href='javascript:send($i);'>$i</a></b>&nbsp;");
}
}
if(($total_rows % $limit) != 0)
{
if($i == $page)
{
echo($i." ");
}
else
{
echo("<a href='javascript:send($i);'>$i</a>");
}
}
if(($total_rows - ($limit * $page)) >= 0)
{
$pagenext = $page +1;
echo("&nbsp;<b><a href='javascript:send($pagenext);'>next</a></b> ");
}
else
{
echo("&nbsp;next&nbsp;");
}
mysql_free_result($result);
?>
</form>
</html>