Okay, I got a lot of help from pogenwurst.
The new code is as follows..
- 2 problems: Every page has shows the same user results & last page is labeled 6.2 instead of 6 or 7

<?php
// PERFORM QUERY & POPULATE TABLE
 $query = 'SELECT id, username, iwins, ilosses, ipoints FROM punbb2_users' . ' ORDER by ipoints DESC LIMIT 0 , 15' ;
 $result = mysql_query($query) or die('Query failed: ' . mysql_error());

if ($db->num_rows($result))
{
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo "\t<tr>\n";
?>

    <td class="tcl" scope="col"><?php echo '<a href="iprofile.php?id='.$line['id'].'">'.pun_htmlspecialchars($line['username']).'</a>' ?></td>
    <td class="tc2" scope="col"><?php echo $line['iwins']; ?></td>
    <td class="tc3" scope="col"><?php echo $line['ilosses']; ?></td>
    <td class="tc4" scope="col"><center><?php echo $line['ipoints']; ?></center></td>        

<?php
          }
    echo "\t</tr>\n";
}
echo "</table>\n";
//END TABLE


//BEGIN PAGINATE
$result = $db->query('SELECT COUNT(id)-1 FROM '.$db->prefix.'users') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
 $query_rows = $db->result($result);

$num_pages = ceil($query_rows) / 15;

if (intval($_GET['p']) && $_GET['p'] <= $num_pages) 
$cur_page = $_GET['p'];

$link_to = 'ladder2.php?foo=bar';

echo '<center>Page:'.paginate($num_pages, $cur_page, $link_to).'</center>';
//END PAGINATE

?>

*the page can be seen here, different url from first post. (testing page)

Mild progress is underway. I need a little help with the "record to start at". How do I tell it to use that $_GET statement?

LoL, yea, I got caught up in this thing I was reading earlier.
Smartyrs go read my thread with the whole LIMIT thing.

Thats prolly the best idea; there may be an exploit where you can use some code in the description, if it allows it, and stop it from echoing anything after what you type.

oops I meant to say limit heh..
Are you sure it wouldnt be LIMIT x, #
or will it make a difference

also I would need to assign a variable to your little $_GET(...) global there wouldnt I?

Can I see an example of how you would write this query?

LIMIT 15,X WHERE X = $X

$X = $_GET( blah blah )? ? ?

hmm confused

Well there is a reason I am not doing that. It is not my website to do that with. Once I finish coding this site  I plan on getting a new url.

Any advice on the whole paginate thing? I think I need to add a LIST x,#  clause to the query but I don't know where to go from there.

Not sure exactly what you mean. I don't know if this is it but, you actually can see certain links like iladder there when you log in.

Okay I want to have a new page for every x number of results that are queried in a table. The page can be seen here.

Here is how I coded the thing

<?php
// Perform the query
 $query = 'SELECT id, username, iwins, ilosses, ipoints FROM xusers' . ' ORDER by ipoints DESC' ;
 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    
    $id = '<a href="profile.php?id='.$line['id'].'">'.pun_htmlspecialchars($line['username']).'</a>' ;

if ($db->num_rows($result))
{
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo "\t<tr>\n";


            
        
?>

    <td class="tcl" scope="col"><?php echo '<a href="iprofile.php?id='.$line['id'].'">'.pun_htmlspecialchars($line['username']).'</a>' ?></td>
    <td class="tc2" scope="col"><?php echo $line['iwins']; ?></td>
    <td class="tc3" scope="col"><?php echo $line['ilosses']; ?></td>
    <td class="tc4" scope="col"><?php echo $line['ipoints']; ?></td>        

<?php
          }
    echo "\t</tr>\n";
}
echo "</table>\n";

?>

*note if you are looking through the features on the site you will notice that the ladder is incomplete, specifically the iprofile pages which I am currently working on aswell and fixing up db for it.

edited: hid some of query

Yea I actually got it all working again I was gona dlt post.

You are right though, I used a WHERE clause to get everything going.

Thanks

<?php
// This is where I get user info
$query = 'SELECT id, username, iwins, ilosses, ipoints FROM punbb2_users';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
        
$line = mysql_fetch_array($result, MYSQL_ASSOC);
?>

<dl>
     <dt>Player: </dt>
    <dd><?php echo $line['username'] ?></dd>
    <dt>Wins:</dt>
    <dd><?php echo $line['iwins'] ?></dd>
    <dt>Losses:</dt>
    <dd><?php echo $line['ilosses'] ?></dd>
    <dt>Points:</dt>
    <dd><?php echo $line['ipoints'] ?></dd>
    <dt>To Player:</dt>
    <dd><a href="">Send Challenge</a><a href=""> </a></dd>

Okay so this is part of a custom profile I created for my users. To see an example go to this site. Click one of the usernames and it will take you to the page where the above code is used.

Now the problem is that it is always using the same user to output no matter which user you click on. Why is this happening? How can I fix it?
If you want more info leme know.

Hey, thanks lol. I did share it, it's up there. What do you want to know?

I guess Ill bump this, I have some stuff to add.

Okay, so here are a couple new links u can use to see what I am working on (more aesthetically pleasing for the moment)
iBattle
This link is where you set up a challenge with another player. What I am trying to do is that when the opponent value is selected, the title will input that value of the player beside your name ($pun_user) versus ($opponent). Unfortunately I am having a lot of trouble determining how to write the oponent variable. Check my code above for an example. PLEASE HELP

iLadder
Here is where the results are printed out. They use the same code as that drop down menu for opponents in the first example. Except they also include rows iwins ilosses and ipoints.

Any replies are welcome..

Okay so I am creating a ladder system based on poll votes from the Easy poll 2.0 mod.

//See Next Post For More Info and new links!

(second page is a query that looks for wins losses and points based on username (which are new rows that I inserted into the user table))
/* Also note that I am not styling it until it is fully functional with the site */

Here is some of the source from the first page:

<?php
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';
?>


<div class="blockform">
<h2><span>Improv Ladder: Battle</span></h2>
<div class="box">
    <form id="post" method="post" action="post.php?action=post&fid=15" onsubmit="return process_form(this)">
<div class="inform">
<fieldset>
<legend>Good luck, have fun!</legend>
<div class="infldset">
    <input type="hidden" name="ptype" value="1" />
<label><strong>...</strong><br /><input type="text" name="req_question" value="Who won the battle?" readonly="" size="80" maxlength="70" tabindex="1" /><br /><br /></label>
<label><strong>You:</strong><br />
<select name="poll_option[1]">
    <option value="<?php echo $pun_user['username']; ?>" selected="selected"><?php echo $pun_user['username']; ?></option>
</select> 
<br /></label>

<label><strong>Opponent:</strong><br />
<?php 
// Perform the query
 $query = 'SELECT username FROM punbb2_users' . ' ORDER by username ASC' ;
 $result = mysql_query($query) or die('Query failed: ' . mysql_error());

// Print results in html

echo "<select name='poll_option[2]'>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($line as $col_value) {
        echo "\t\t<option>$col_value</option>\n";
    }
    echo "\t</tr>\n";
}
echo "</select>\n";

// define opponent, the variable is used later on as you can see (for the title of the poll) 
/* $opponent = */
   
?>

<br /></label>
                
            
            </div></fieldset></div>            <div class="inform">
                <fieldset>

                    <legend>Include video links</legend>
                    <div class="infldset txtarea">
                        <input type="hidden" name="form_sent" value="1" />
                        <input type="hidden" name="form_user" value="<?php echo $pun_user['username']; ?>" />
                        <label><strong>Subject</strong><br /><input class="longinput" type="text" name="req_subject" value="<?php echo $pun_user['username']; ?> versus <?php echo $opponent; ?>" size="80" maxlength="70" tabindex="100" /><br /></label>
                        <label><strong>Video links + info</strong><br />
                        <textarea name="req_message" rows="20" cols="95" tabindex="101"></textarea><br /></label>

If you look through the code you can see that one of the problems is using the second selected user option in the page title. I have tried numerous things to get it to work. Any ideas would be great. If you need more info or have comments PLEASE SHARE.

Thank you very much Strofanto. I will try your suggestions when I get back tonight.

Well you did give me an idea actually but.. as you can see here that it's just a thin little image so if it doesn't repeat then it will just add a small bar and not actually be a background. I will try some more stuff.

More advice would be great though, even on general styling issues.

/* I posted this on punres.org also a couple of hours ago, no response yet. I have to go out soon so I figured I'd see if anyone had some advice atm. */


Alright I am trying customize my punbb. It may not look great right now because I plan to redo all of the photoshop I have done so far; it will look significantly different when completed. What's there is just place settings kind of to get the feel of editing it properly.

http://thpsvids.com/gfg

The main problem I'm having is that border. It repeats right down the entire length of page. I have tried creating custom docs in the include/user folder and linking that image from include/template/main.tpl, with no result (I created some other elements using that technique). Currently the border is set up in the actual template .css file (Minima.css).

Oh, also the footer is not aligning to the actual bottom of the page like the header is.

Anyway I can't think of any other information to post at the moment, all though I'm sure I will later. So please let me hear your thoughts/questions/etc.

- Thanks,
Towelie