This is what i did...
$max_result = 5;
echo "<table width='100%' border='1'>
<tr><td>File Name<td>Description<td>Content-type<td>Downloaded<td>Contributed by:</tr><tr><td colspan=5> </tr>";
$sql = "SELECT * FROM " . $GLOBALS['prefix'] . "files WHERE `category`='". $HTTP_GET_VARS['catId'] ."'";
$retid = mysql_query ( $sql );
while ($row=mysql_fetch_array ( $retid ) )
{
$sql_get_user = "SELECT username FROM `" . $GLOBALS['prefix'] . "users` WHERE `id` = '" . $row['poster'] ."'";
$retid_get_user = mysql_query ( $sql_get_user );
$row_get_user = mysql_fetch_array ( $retid_get_user );
printf ("<tr><td><a href='download.php?id=%s'>%s</a><td>%s<td>%s<td>%s<td><a href='usercp.php?userid=%s'>%s</a></tr>",
$row['id'], $row['filename'], $row['description'], $row['content-type'],
$row['downloaded'], $row['poster'], $row_get_user['username'] );
}
echo "</table><br>";
echo "
<a href='?page=1'> [1]</a>
<a href='?page=2'>[2] </a>
<a href='?page=3'>[3] </a>
...
...
...
<a href='?page=n'>[n]</a>
";
// WHERE 'n' depends on the result.
The page number link should work...
thanks in advance!
