Then I suggest that you have a knowledge of HTML before you encounter coding HTML.  If you cannot identify whether you are using html or xhtml...you are in trouble!!!

Keep copying and copying from other people's layouts will not help.  Try to spend some times to read the tutorials and have an idea of what you are doing.  That way it will be easier to fix troubleshoots later on. 

If you do not know how to do table, I can link you thousands of site for help but I'll will only list the site that are useful.  See what others have to say and code it yourself. 

I learn by the hardest way, I actually wrote down the code on papers (wasting papers), but then I learn it by retyping it on the computer. I'm not suggesting you to use my way, but how is it possible to help someone who have no knowledge about HTML?  I'm not trying to criticize you, I'm trying to state a point.  However, I would be glad to help you.

Here are some of the tutorials that you can use:
>> Lissa Explains Table
>> W3Schools
>> Reminiscent Tutorials
>> Celestial Star HTML and XHTML
>> Pootato-Coding A Layout

Then how about try to change div style into table?  Maybe it will work better?
Um, maybe the coding is a little bit weird. 

I cannot determine which doctype of html you are using.  Are you using xhtml or HTML 4.0 Transitional or Strict? 

If you are using transitional.
<link rel="stylesheet" href="style.css" type="text/css" />  That back slash is extra.

Try this:

Code:

#wrapper {   
padding: 0;   
background: url(/premades/grass/images/grassbg.jpg) center repeat-y;
   margin: auto;   
   width: 565px;   
   text-align: center; 
}

I replaced $q with $query and it really work.  Thank you so much 

  I'm losing my concentration.  I'm not frustrated, but I cannot get this thing to work.  I tried for a month now, still not dare to post it up...but I will now since I can't find what is the problem.  I'm very poor with wording, so hopefully the way I display things will be easier for you guys to see.

Main Point:  Cannot get the database to show the avatar in a certain series. 
Trying: To get the series list to work when you click on a series name.

Tutorial: Click Here

Normal Avatars Page: Avatars

Code:

<?php

// include database connection here

$query = "select * from avatars WHERE type='100x100' order by id desc ";

$result = mysql_query($query, $connection) or die ("Could not execute query : $query ." . mysql_error());  
$rows = mysql_num_rows($result); 
if ($rows=="0") { echo "No avatars with type 100x100 were found."; } 

$cat = strip_tags(mysql_escape_string($_GET['cat']));

if($cat != "") {
$q="select * from avatars WHERE series = '$cat' ORDER by id desc ";
} else {
$q="select * from avatars order by id desc ";
} 


// Insert Code A Here

// dynamic navigation variables
$screen = $_GET['screen'];
$PHP_SELF = $_SERVER['PHP_SELF'];

$rows_per_page=10;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);

if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$query .= "LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query." . mysql_error());

// create the dynamic links 
if ($screen > 0) { 
        $j = $screen - 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "<a href=\"$url\">&laquo; Prev</a>";    // I replaced the Prev with the &laquo; which is <<  
        } 
         
        // page numbering links now 
        $p = 7;                                // number of links to display per page 
        $lower = $p;                    // set the lower limit to $p 
        $upper = $screen+$p;        // set the upper limit to current page + number of links per page 
        while($upper>$pages){ 
            $p = $p-1; 
            $upper = $screen+$p; 
        } 
        if($p<$lower){ 
            $y = $lower-$p; 
            $to = $screen-$y; 
            while($to<0){ 
                $to++; 
            } 
        } 
         
        if(!empty($to)) 
        { 
            for ($i=$to;$i<$screen;$i++){ 
                $url = "$PHP_SELF?screen=" . $i; 
                $j = $i + 1; 
                echo " | <a href=\"$url\">$j</a> | "; 
            } 
        } 
         
        for ($i=$screen;$i<$upper;$i++) { 
            $url = "$PHP_SELF?screen=" . $i; 
            $j = $i + 1; 
            echo " | <a href=\"$url\">$j</a> "; 
        } 
         
        if ($screen < $pages-1) { 
        $j = $screen + 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "| <a href=\"$url\">Next &raquo;</a>";   // I replaced the Next with the &raquo; which is >>  
        } 

$i=0; // set the column indicator

$columns=3;

echo "<br><br><center><table cellspacing=\"1\">"; // open table tag here

while($row=mysql_fetch_array($result))
{
extract($row); // extract row values

$id=$row["id"];
$artist=$row["artist"];
$date=$row["date"];
$type=$row["type"];
$series=$row["series"];
$thumb=$row["thumb"];
$preview=$row["preview"];
$pcounter=$row["pcounter"];


if ($i==0)

{
echo "<tr><td width=\"195\" class=\"code\" valign=\"top\">
<center><a href=\"download/avatars.php?id=$id\" onClick=\"MyWindow=window.open('download/avatars.php?id=$id','MyWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,
resizable=no,width=140,height=140,left=200,top=250');return false;\" target=\"_blank\">
<img src=\"$thumb\" border=\"0\" alt=\"DSD Avatars\"></a>
</center><br> &#38;#187;<b> ID:</b> $id 
    <br>&#38;#187; <b>Artist:</b> $artist
    <br>&#38;#187; <b>Series:</b> $series
    <br>&#38;#187; <b>Date:</b> $date
    <br>&#38;#187; <b>Type:</b> $type
    <br>&#38;#187; <b>Download</b> [$pcounter]</td>";
}

else
{
echo "<td width=\"195\" class=\"code\">
<center><a href=\"download/avatars.php?id=$id\" onClick=\"MyWindow=window.open('download/avatars.php?id=$id','MyWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,
resizable=no,width=140,height=140,left=200,top=250');return false;\" target=\"_blank\">
<img src=\"$thumb\" border=\"0\" alt=\"DSD Avatars\"></a>
</center><br> &#38;#187;<b> ID:</b> $id 
    <br>&#38;#187; <b>Artist:</b> $artist
    <br>&#38;#187; <b>Series:</b> $series
    <br>&#38;#187; <b>Date:</b> $date
    <br>&#38;#187; <b>Type:</b> $type
    <br>&#38;#187; <b>Download</b> [$pcounter]</td></tr>";
}
 
$i++; 

if($i==$columns-1) { $i=0; }

} 

echo "</table><br></center>"; // close table

//The navigation coding for the links here


// Insert Code B Here 

// create the dynamic links 
if ($screen > 0) { 
        $j = $screen - 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "<a href=\"$url\">&laquo; Prev</a>";    // I replaced the Prev with the &laquo; which is <<  
        } 
         
        // page numbering links now 
        $p = 7;                                // number of links to display per page 
        $lower = $p;                    // set the lower limit to $p 
        $upper = $screen+$p;        // set the upper limit to current page + number of links per page 
        while($upper>$pages){ 
            $p = $p-1; 
            $upper = $screen+$p; 
        } 
        if($p<$lower){ 
            $y = $lower-$p; 
            $to = $screen-$y; 
            while($to<0){ 
                $to++; 
            } 
        } 
         
        if(!empty($to)) 
        { 
            for ($i=$to;$i<$screen;$i++){ 
                $url = "$PHP_SELF?screen=" . $i; 
                $j = $i + 1; 
                echo " | <a href=\"$url\">$j</a> | "; 
            } 
        } 
         
        for ($i=$screen;$i<$upper;$i++) { 
            $url = "$PHP_SELF?screen=" . $i; 
            $j = $i + 1; 
            echo " | <a href=\"$url\">$j</a> "; 
        } 
         
        if ($screen < $pages-1) { 
        $j = $screen + 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "| <a href=\"$url\">Next &raquo;</a>";   // I replaced the Next with the &raquo; which is >>  
        } 
         
?>

The avatar series list: Click Here

Code:

<?php

//dbconnection here

$query = "SELECT DISTINCT series FROM avatars order by series asc ";
$result= mysql_query($query, $connection) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result)) {
$series=$row["series"];

$cat = strip_tags(mysql_escape_string($_REQUEST['cat']));

$q = mysql_query("select * from `avatars` where `series`='$series'");
$numrows = mysql_num_rows($q);

echo ?>


&raquo; <a href="avatars_slist.php?cat=<?php echo "$series"; ?>">
<?php echo "$series"; ?></a> [<b><?php echo "$numrows"; ?></b>]</b><br>
 
<?php
;
}
?>

Finally the avatars_slist.php: For Example Series Fafner

Code:

<?php

//dbconnection here

$result = mysql_query($query, $connection) or die ("Could not execute query : $query ." . mysql_error());  
$rows = mysql_num_rows($result); 
if ($rows=="0") { echo "No avatars with type 100x100 were found. Please come back for further more updates."; } 

$cat = strip_tags(mysql_escape_string($_GET['cat']));

if($cat != "") {
$q="select * from avatars WHERE series = '$cat' ORDER by id desc ";
} else {
$q="select * from avatars order by id desc ";
} 

// Insert Code A Here

// dynamic navigation variables
$screen = $_GET['screen'];
$PHP_SELF = $_SERVER['PHP_SELF'];

$rows_per_page=8;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);

if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$query .= "LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query." . mysql_error());

// create the dynamic links 
if ($screen > 0) { 
        $j = $screen - 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "<a href=\"$url\">&laquo; Prev</a>";    // I replaced the Prev with the &laquo; which is <<  
        } 
         
        // page numbering links now 
        $p = 7;                                // number of links to display per page 
        $lower = $p;                    // set the lower limit to $p 
        $upper = $screen+$p;        // set the upper limit to current page + number of links per page 
        while($upper>$pages){ 
            $p = $p-1; 
            $upper = $screen+$p; 
        } 
        if($p<$lower){ 
            $y = $lower-$p; 
            $to = $screen-$y; 
            while($to<0){ 
                $to++; 
            } 
        } 
         
        if(!empty($to)) 
        { 
            for ($i=$to;$i<$screen;$i++){ 
                $url = "$PHP_SELF?screen=" . $i; 
                $j = $i + 1; 
                echo " | <a href=\"$url\">$j</a> | "; 
            } 
        } 
         
        for ($i=$screen;$i<$upper;$i++) { 
            $url = "$PHP_SELF?screen=" . $i; 
            $j = $i + 1; 
            echo " | <a href=\"$url\">$j</a> "; 
        } 
         
        if ($screen < $pages-1) { 
        $j = $screen + 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "| <a href=\"$url\">Next &raquo;</a>";   // I replaced the Next with the &raquo; which is >>  
        } 

$i=0; // set the column indicator

$columns=2;

echo "<br><br><center><table valign=\"top\" cellspacing=\"3\">"; // open table tag here

while($row=mysql_fetch_array($result))
{
extract($row); // extract row values

$id=$row["id"];
$artist=$row["artist"];
$date=$row["date"];
$type=$row["type"];
$series=$row["series"];
$thumb=$row["thumb"];
$preview=$row["preview"];
$pcounter=$row["pcounter"];


if ($i==0)

{
echo "<tr><td width=\"188\" margin=\"10px\" cellpadding=\"2\" class=\"code\" valing=\"top\">
<center><a href=\"download/avatars.php?id=$id\" onClick=\"MyWindow=window.open('download/avatars.php?id=$id','MyWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,
scrollbars=no,resizable=no,width=140,height=140,left=200,top=250');return false;\" target=\"_blank\"><img src=\"$thumb\" border=\"0\" oncontextmenu=\"return false;\"></img></a>
</center><br> &#38;#187;<b> ID:</b> $id 
    <br>&#38;#187; <b>Artist:</b> $artist
    <br>&#38;#187; <b>Series:</b> $series
    <br>&#38;#187; <b>Date:</b> $date
    <br>&#38;#187; <b>Type:</b> $type
    <br>&#38;#187; <b>Download</b> [$pcounter]</td>";
}

else
{
echo "<td width=\"188\" margin=\"10px\" cellpadding=\"2\" class=\"code\" valign=\"top\">
<center><a href=\"download/avatars.php?id=$id\" onClick=\"MyWindow=window.open('download/avatars.php?id=$id','MyWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,
scrollbars=no,resizable=no,width=140,height=140,left=200,top=250');return false;\" target=\"_blank\"><img src=\"$thumb\" border=\"0\" oncontextmenu=\"return false;\"></img></a>
</center><br> &#38;#187;<b> ID:</b> $id 
    <br>&#38;#187; <b>Artist:</b> $artist
    <br>&#38;#187; <b>Series:</b> $series
    <br>&#38;#187; <b>Date:</b> $date
    <br>&#38;#187; <b>Type:</b> $type
    <br>&#38;#187; <b>Download</b> [$pcounter]</td></tr>";
}
 
$i++; 

if($i==$columns-1) { $i=0; }

} 

echo "</table><br></center>"; // close table

//The navigation coding for the links here

// Insert Code B Here 

// create the dynamic links 
if ($screen > 0) { 
        $j = $screen - 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "<a href=\"$url\">&laquo; Prev</a>";    // I replaced the Prev with the &laquo; which is <<  
        } 
         
        // page numbering links now 
        $p = 7;                                // number of links to display per page 
        $lower = $p;                    // set the lower limit to $p 
        $upper = $screen+$p;        // set the upper limit to current page + number of links per page 
        while($upper>$pages){ 
            $p = $p-1; 
            $upper = $screen+$p; 
        } 
        if($p<$lower){ 
            $y = $lower-$p; 
            $to = $screen-$y; 
            while($to<0){ 
                $to++; 
            } 
        } 
         
        if(!empty($to)) 
        { 
            for ($i=$to;$i<$screen;$i++){ 
                $url = "$PHP_SELF?screen=" . $i; 
                $j = $i + 1; 
                echo " | <a href=\"$url\">$j</a> | "; 
            } 
        } 
         
        for ($i=$screen;$i<$upper;$i++) { 
            $url = "$PHP_SELF?screen=" . $i; 
            $j = $i + 1; 
            echo " | <a href=\"$url\">$j</a> "; 
        } 
         
        if ($screen < $pages-1) { 
        $j = $screen + 1; 
        $url = "$PHP_SELF?screen=$j"; 
        echo "| <a href=\"$url\">Next &raquo;</a>";   // I replaced the Next with the &raquo; which is >>  
        } 
      
?>

If you can find out why, I'm really appreciate your help.

Hello and welcome to the forum, I'm just 5 years younger than you are but I'm getting there.  Anyway, hope you have a fun time here.

Maybe you should try to put the topbanner into table format.  If using table then I would use class="blah" rather than id="blah". 

You can just keep the code the way they are but just try to add table with colspan=2 and hopefully it will work.

If it doesn't work, then we'll try something else.

Oh my goodness,     I was going to try it out, but I guess I don't have to anymore.  Glad you found out the problem. 

Hello and welcome to the forum

I'm Yashima and it's a pleasure to meet you.  I been here for awhile, so if you need any help, you can always ask

Hm...This is a tough situation.  Give me a few days (7) to try the code and work it out.  Hopefully maybe I can find something missing or why is it incorrect.  Sorry for the long wait.  I can't figure out why it behave that way.  I'll try my best to help out as I can.

Great work   The avatars look good.  I especially like the 14th on the list ^^  That one has a nice feeling.  Your avatars remind me of the coming season very soon and that is Summer when school end and a new season hit. ^_^

It will be really active when summer hits and school is over.  I'm so sure of it lol.  ^_^  Welcome to the forum.  I'm Yashima, we're the same age?  I hope?  well I'm 17 but yea birthday is early xD.

The code seem right, but I don't know what is wrong with it.  Maybe it's something to do with when you insert into the database.  Check your sql in the database.

Did you do this coding by yourself?  Or did you get it from a tutorial or a site?  If you did get it from a tutorial, may I see the site to see what's going on.  Maybe it will be clearer. 

I finally notice that when you click 50x100 it link to 120x120 and every single one of them link to 120x120.  (sorry I didnt see it earlier -__-)

That's great   Glad it work out okay for you.  As for other database, it's the same way.  Once you get the hang of it, other database should be a piece of cake   Have fun ^^.

Yes the backslash are necessary for the coding.  I like to use it like this, so not many

Code:

<?php echo "$blah"; ?>

which is very confusing to me.  However, to some people, they may think that <?php echo "$blah"; ?> is breaking up the code into simpler code made it easier for them to read.  On the other hand, I like how it's just one big code, with less <?php echo "$blah"; ?> make it easier for me.

I really dont know, it's really depend on how you want it to be.  Because the way I use, echoing....<center><table valign=\"top\" cellspacing=\"1\"> in a normal source code, will come out

Code:

<center><table valign="top" cellspacing="1">

If you don't have backslash, I'm 100% sure that your code will end up with something error messages.  The echo cannot take too much """""""""""" quotation marks so back slash help it identify better.  I hope I make sense xD.