<?php
$USERS_PER_PAGE = 20; //number of users to be displayed on one page

$tbl_name="forum_question";
$tbl_name2="forum_answer";
$max_pages = 0;
$query = "SELECT COUNT(*) as num FROM $tbl_name ORDER BY reply DESC;";
$result = mysql_query($query);
if ($result !== false) {
	$row = mysql_fetch_assoc($result);
	$max_pages = ceil($row['num'] / $USERS_PER_PAGE);
}

$page = 1;
if (isset($_GET['page'])) {                                                  
	$page = intval($_GET['page']);
	if ($page < 1) { $page = 1;}
	if ($page > $max_pages) { $page = $max_pages; }
}


$limit = ' LIMIT '.($page-1)*$USERS_PER_PAGE.', '.$USERS_PER_PAGE.' ';
$query = mysql_query("SELECT * FROM $table_name INNER JOIN $table_name2 ONE table_name.name = table_name2.a_name ORDER BY a_datetime DESC $limit");
printPagination($page, $max_pages, 'main_forum.php?');
while ($rows = mysql_fetch_assoc($query))
{
?>

I'm getting an

Quote

I'm trying to retrieve the user with the most post.

Thank you.

Okay So is it possible for me to just go back and simplify one part of the code? I want to simply

S rank vs S rank

. and winner gets

+75 loser get -100.

Sort of like:

// S vs S rank
if ($difference == 10){
$points = $points + 75;
$points1 = $points1 - 100;
}

But I'm afraid the

// D vs D rank
if ($difference == 0){
$points = $points + 65;
$points1 = $points1 - 30;
}

Won't allow me to do that.

Well, Yes, but I can upload a signature that is 500x500. and It wont re size that.