Your tutorial is simple but very thorough.  Thanks for sharing it with us!

Glad to have you in the group! 

Sorry to hear about the bad day, but I hope you enjoy your new membership in this friendly club!

Which a:hover in your stylesheet are you referring to?  There appear to be several on the page.

I just tested giving the <h3> tag a padding of 20 pixels, with the tag set at the top, and it worked fine for me.  Here's the exact CSS I used for the tag:

Code:

h3 { font-size: 13px;
margin-top: 30px; }

I was previewing a post within the coding section of the forum, and found that the preview box was pushed to the right and expanded my 1024x768 resolution screen.

You would need to align the image to the left, like so:

Code:

<img src="URL" align="left">words words words words words words words

Just align all images to the left, and the words should wrap around the pictures rather than be pushed down.

I'm sorry to say Mora doesn't accept link exchanges at this time, and because of reconstruction the affiliation will be temporarily closed.

Thankfully the problem's been solved.  Apparently the series page was incorrectly querying the database by using the sql command rather than the query command.

I've used this same database for other areas of my site and the sql works fine.  Also, the code is a mix of tutorials and my own creation, so there's not really one site where you may find an example.

I also doubt the coding could get much cleaner, since I've eliminated all I can.

The icon images haven't fully be uploaded yet, so the database is reading empty areas.  Also, the size of the images can be read beside the image.

And sure, I can repost the code (slightly modified but still useless to me).  If you think a screenshot of the page will help, then it would be great to see one.

The icon navigation:

Code:

<?php
mysql_connect(localhost,animara_ham,Alucard666);
@mysql_select_db(animara_graphics) or die( "Unable to select database");

$query = "SELECT DISTINCT size, size_id FROM icons WHERE `size`='50x100'";
$result = mysql_query($query);

while($row=mysql_fetch_array($result))
{

$size_id=$row["size_id"];

echo "<a href=\"iconssize.php?size_id=$size_id\">50x100 Icons";
}
?>
<div class="bottomnav"><?php

mysql_connect(localhost,user,pw);
@mysql_select_db(db) or die( "Unable to select database");

$query="select * from icons WHERE `size` = '50x100' ";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "~ $num unique icons";

?></div></A>

And the iconssize.php page (full code this time):

Code:

<?php

if (is_numeric($_GET["size_id"]))
{
$size_id = $_GET["size_id"];
}

mysql_connect(localhost,user,pw);
@mysql_select_db(db) or die( "Unable to select database");

$sql="SELECT * FROM `icons` WHERE `size_id` = '$size_id' ORDER BY date desc";
$result = mysql_query( $sql ) or die(mysql_error());

// Insert Code A Here

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

$rows_per_page=4;
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);
$last = $pages -1;

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());

$i=2;
echo '<table align="center">';

while ($row = mysql_fetch_array($result))
{

extract($row);

$contents_here = '<table align="center" class="header">
<tr><th height="120">
<img src="'.$url.'" title="avatar" alt="avatar">
<td width="120">
<br><b>Size:</b><br>~ '.$size.'
</table>';

if ($i==0)
{
echo '<tr><td>'.$contents_here.'</td>';
}

else if ($i==2)
{
echo '<td>'.$contents_here.'</td>';
}

else
{
echo '<td>'.$contents_here.'</td>';
}

$i++; $i=$i%2;

}
echo '</table>

<center>
<div class="pagenav">';

if ($screen == 0)
{
}
else
{
echo "<a href=\"$PHP_SELF?a=show&size=$size2&screen=0\">&laquo;&laquo;</a>";
}

// Put Code C Here

        // create the dynamic links
        if ($screen > 0) {
        $j = $screen - 1;
        $url = "$PHP_SELF?a=show&size=$size2&screen=$j";
        echo "<a href=\"$url\">&laquo;</a>";
        }
        
        // page numbering links now
        $p = 3;                                // 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?a=show&size=$size2&screen=" . $i;
                $j = $i + 1;
                echo "<a href=\"$url\">$j</a>";
            }
        }
        
        for ($i=$screen;$i<$upper;$i++) {
            $url = "$PHP_SELF?a=show&size=$size2&screen=" . $i;
            $j = $i + 1;
            echo "<a href=\"$url\">$j</a>";
        }
        
        if ($screen < $pages-1) {
        $j = $screen + 1;
        $url = "$PHP_SELF?a=show&size=$size2&screen=$j";
        echo "<a href=\"$url\">&raquo;</a>";
        }

if ($screen == $last)
{
}
else {
echo "<a href=\"$PHP_SELF?a=show&size=$size2&screen=$last\">&raquo;&raquo;</a>";
}

        ?>

I've found that a part of my problem was a repeating script with this line:

while( $row = mysql_fetch_array( $result ) ) {

extract($row);

above the dynamic pagination script.  However, the problem still persists with clicking the links.

I'm not sure where you tried the icon links, as I am dealing with an experimental site and not my main site. 

And unfortunately, the problem appears to be coming from the iconssize.php page rather than the index page of the icons.  The navigation links display the correct size id, but upon entering the iconssize.php page the information displayed is incorrect.

Here's a working example of the problem.  When the links in the Icon navigation are clicked, they merely lead to a page repeating the 120x120 icons.  However, the '.$size.' field placed in the header of the page (Icons - '.$size.') depicts the correct size.

I'm currently trying to create a php-based website, including in the navigation area, with as few pages as possible.  Right now I'm working on the icons database and have run into problems with selecting the correct size of the icon.  For example, a visitor is to click the link 50x100 icons, which is then to take them to a new page.

The php code for the navigation:

Code:

<?php
mysql_connect(localhost,user,pw);
@mysql_select_db(db) or die( "Unable to select database");

$query = "select * from icons WHERE size like '%50x100%' LIMIT 1 ";
$result = mysql_query($query);

while($row=mysql_fetch_array($result))
{

$size_id=$row["size_id"];

echo "<a href=\"iconssize.php?size_id=$size_id\">50x100 Icons";
}
?>

The visitor is correctly transported to the iconssize page, but the icons shown are incorrect.  The page will only show the 120x120 size icons, but if I place the $size_id above the icons in a header, the correct size is shown.  I also cannot ORDER the icons, which makes me believe there is a disconnect somewhere in my code.  I've tried numerous ways to show the correct icons, but to no avail.

Here's the iconssize.php page (I've removed the pagination for simplification):

Code:

<?php

if (is_numeric($_GET["size_id"]))
{
$size_id = $_GET["size_id"];
}

mysql_connect(localhost,user,pw);
@mysql_select_db(db) or die( "Unable to select database");
$sql="SELECT * FROM `icons` WHERE `size_id` = '$size_id' ORDER BY date desc";
$result = mysql_query( $sql ) or die(mysql_error());

while( $row = mysql_fetch_array( $result ) ) {

extract($row);

// 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);
$last = $pages -1;

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());

$i=2;
echo '<div class="head">Icons - '.$size.'</div>
<table align="center">';

while ($row = mysql_fetch_array($result))
{

extract($row);

$contents_here = '<table align="center" class="header">
<tr><th height="120">
<img src="'.$url.'" title="icon" alt="icon">
<td width="120">
<b>Series:</b><br><div class="indent">'.$series.'</div>
<b>Size:</b><br><div class="indent">'.$size.'</div>
<b>Added:</b><br><div class="indent">'.$date.'</div>
</table>';

if ($i==0)
{
echo '<tr><td>'.$contents_here.'</td>';
}

else if ($i==2)
{
echo '<td>'.$contents_here.'</td>';
}

else
{
echo '<td>'.$contents_here.'</td>';
}

$i++; $i=$i%2;

}
echo '</table>

<center>
<div class="pagenav">';

        ?>

I am also currently looking for an affiliate for my graphics site, and your DX site is quite extraordinary.  If you'd like to consider me, my site may be found here for viewing.