I for some reason cannot get this to display correctly...What I want is the image displayed then the text under it, I could manage to get it any and every other possible way but the right way. :S

echo "<table>";
while($row = mysql_fetch_array($result)) {

echo "<tr>";
echo "<img src=\"http://www.webmaster-talk.com/images/$row[element_5]\" border=\"1\" width='$maxwidth' alt=\"$row[element_1]\" title=\"$row[element_1]\">";

echo "<tr>";
echo "<a href=\"$row[element_2]\">$row[element_1]</a>";

}

element_1 = Text
element_2 = URL
element_5 = Image

Has everybody now forgotten how to construct a table??

<table>
<tr>
<td>Content col1</td>
<td>Content col2</td>
</tr>
</table>

I'm not quite that bad at my html chris, but probably still that bad in my php / html combined.

Anyway here's the php code that I am working with: It's the last block of the echoed html code near the bottom..I have commented out the block of echoed html code right above that as it's not required for the below code to function (main difference is the maxwidth part). Note the echoed "<table>"; code near the top.

<?php
                             // Begin Resize Image To Specific Dimensions Code //

    $dir = "images/"; //dir of your images
    $exten1 = "jpg"; //extension -> jpg / gif / png
    $exten2 = "png"; //extension
    $exten3 = "gif"; //extension
    
    $maxwidth = '190'; //maximum width
    if ($handle = @opendir($dir)) 

    echo "<table>";
    
    {
    
    while (false !== ($file = @readdir($handle))) { 
    $bestand = $dir ."/". $file;
    $ext = pathinfo($bestand);
    if($ext['extension'] == $exten1 || $ext['extension'] == $exten2 || $ext['extension'] == $exten3)
    
    while($row = mysql_fetch_array($result)) {
    {

    $width = getimagesize($bestand);
    if($width[0]<$maxwidth)
    
    {
    
    /*
    echo "<td align=\"center\">";
    echo "<a href=\"http://localhost/scripts/index.php?id=$row[$id]\"><img border=\"1\" src=\"images/$row[element_5]\" alt=\"$row[element_1]\" title=\"$row[element_1]\">";
    echo "<p />";
    echo "<a href=\"$row[element_2]\">$row[element_1]</a>";
    */
    
    }

    else

    {

    echo "<tr>";
    echo "<td><img src=\"images/$row[element_5]\" border=\"1\" width='$maxwidth' alt=\"$row[element_1]\" title=\"$row[element_1]\"></td>";
    echo "<td><a href=\"$row[element_2]\">$row[element_1]</a></td>";

    } 
    }
    } 
    }

    @closedir($handle); 
    }
 
    echo "</tr>";
    echo "</td>";
    echo "</table>";
    
                             // End Resize Image To Specific Dimensions Code //

?>

I'm not quite that bad at my html

No, I just found it amusing because there was a post earlier in the week where somebody had created a mish mash of <li>s and floated <div>s in an attempt to create a very simple three column table.

I usually don't start messing about echoing the structure because it's easy to get thoroughly lost with what is printing where.

Write out the structure in HTML and just echo the content into the cells

Write out the structure in HTML and just echo the content into the cells

? Bit Lost Here ?

PHP Code:

<table>
<tr>
<td><?php echo('something')?></td>
<td><?php echo('something else')?></td>
</tr>
</table>

It does not add anything significant to the processing time

I tried fixing up the code a bit more to make it more readable, but I still haven't solved the issue.

Someone see something that I might have missed? I don't want one row of images with a column of text next to it, but image then text under it, then image NEXT to FIRST image with text under that, etc..etc..

Note, I didn't forget the closing curly bracket, I left it out of this code

PHP Code:

echo "<table cellpadding=\"5\" cellspacing=\"5\" width=\"100%\" border=\"1\" style=\"border-collapse:collapse;\">";
while($row = mysql_fetch_array($result)) {
echo "<tr><td>";
echo "<img src=\"http://www.webmaster-talk.com/images/$row[element_5]\" border=\"1\" width='$maxwidth' alt=\"$row[element_1]\" title=\"$row[element_1]\">";

// by adding the <br /> tag just before $row[element_1] below, I now have the text UNDER the image, but I want to put the images into separate rows not just one 

echo "<a href=\"$row[element_2]\"><br />$row[element_1]</a>"; 


This is the CLOSEST I could come...

echo "<table align=\"center\" cellpadding=\"5\" cellspacing=\"5\" style=\"border-collapse:collapse;\" width=\"100%\">";
echo "<tr>";
while($row = mysql_fetch_array($result)) {
echo "<td align=\"center\">";
echo "<img src=\"images/$row[element_5]\" border=\"1\" width='$maxwidth' alt=\"$row[element_1]\" title=\"$row[element_1]\">";
echo "<a href=\"$row[element_2]\"><p align=\"center\">$row[element_1]</a>";    
           
    }

Anyone have a solution to getting it to create new rows? I have 6 images currently output to the page, and I only want 5 in this case (or the most to go across without scrolling) then creating a new row.

Originally Posted by chrishirst

Write out the structure in HTML and just echo the content into the cells

If I did that, I would have to wait until the database get's populated...Doesn't make sense to do it that way, but yeah if I had the image pre populated it would work that way.

Still looking for help on this.

I for some reason cannot get this to display correctly...What I want is the image displayed then the text under it, I could manage to get it any and every other possible way but the right way. :S

Why are you using my words without using the quote tags?

Originally Posted by Brian07002

Why are you using my words without using the quote tags?

It was just another sig link spammer.

You need also use (table)(tr) and (td)

Originally Posted by tinyurnet

You need also use (table)(tr) and (td)

care to show where they would go in a situation like the one I am trying to get it in?

Originally Posted by Brian07002

If I did that, I would have to wait until the database get's populated...Doesn't make sense to do it that way, but yeah if I had the image pre populated it would work that way.

Still looking for help on this.

Not sure what you mean by that. Did you know you can do this?

PHP Code:

<?php while($row = mysql_fetch_assoc($result)) {
?>
<tr>
    <td><?php echo $row['something'];?></td>
    <td><?php echo $row['something_else'];?></td>
    <td><?php echo $row['yet_something_else'];?></td>
</tr>
<?php }?>

Amazing how all this code can all serve the purpose for one problem.

Anyway, how about adding it to this:

<html>
<head><title>Get Linked up or Get lost in webspace!</title>
</head>

<?php
$background_color = "#FFFFFF"; // default WHITE background
switch(date(“md”)) {
     
     case 0101:
       // New Years Day background color (light green) on 01/01
       $background_color = "#D5FFD5";
     break;

     case 0202:
       // Ground Hog Day background color (dirty green) on 02/02
       $background_color = "#178E02";
     break;

     case 0214:
       // Valentines Day background color (Pink'ish Purple) on 02/14
       $background_color = "#FE5DCB";
     break;

     case 0422:
       // Earth Day background color (Earth Blue) on 04/22
       $background_color = "#2C7DF8";
     break;

     case 0704:
       // July 4th - Independence Day background color (Yellow) on 07/04
       $background_color = "#FFF20A";
     break;

     case 1111:
       // Veterans Day background color (white) on 11/11
       $background_color = "#FFFFFF";
     break;

     case 1031:
       // automatic halloween background color (light orange) on 10/31
       $background_color = "#FFE6CC";
     break;

     case 1225:
       // xmas day background color (light green) on 12/25
       $background_color = "#D5FFD5";
     break;
}

?>

<body bgcolor="<?php echo($background_color);?>">































<?php

include('config.php');

                                       // Begin Pagination Code //


    $tbl_name="ap_form_1";        //your table name
    // How many adjacent pages should be shown on each side?
    $adjacents = 1;
    
    /*
      First get total number of rows in data table.
      If you have a WHERE clause in your query, make sure you mirror it here.
    */

    $query = "SELECT COUNT(*) as num FROM $tbl_name";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages[num];
    
    /* Setup vars for query. */
    $targetpage = "index.php";     //your file name (the name of this file)
    $limit = 5;             //how many items to show per page
    $page = $_GET['page'];
    if($page)
        $start = ($page - 1) * $limit;             //first item to display on this page
    else
        $start = 0;                                //if no page var is given, set start to 0
    
    /* Get data. */
    $sql = "SELECT * FROM $tbl_name ORDER BY ABS(`element_4`) DESC LIMIT $start, $limit";
    $result = mysql_query($sql);


    /* Setup page vars for display. */
    if ($page == 0) $page = 1;                    //if no page var is given, default to 1.
    $prev = $page - 1;                            //previous page is page - 1
    $next = $page + 1;                            //next page is page + 1
    $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
    $lpm1 = $lastpage - 1;                        //last page minus 1
    
    /*
        Now we apply our rules and draw the pagination object.
        We're actually saving the code to a variable in case we want to draw it more than once.
    */

    $pagination = "";
    if($lastpage > 1)
    {    
    $pagination .= "<div class=\"pagination\">";
    //previous button
    if ($page > 1)
    $pagination.= "<a href=\"$targetpage?page=$prev\"><< previous </a>";
    else
    $pagination.= "<span class=\"disabled\"><< previous </span>";    
      
    //pages    
    if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
    {    
    for ($counter = 1; $counter <= $lastpage; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class=\"current\">$counter</span>";
    else
    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
    }
    }
    elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some
    {
    //close to beginning; only hide later pages
    if($page < 1 + ($adjacents * 2))        
    {
    for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class=\"current\">$counter</span>";
    else
    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
    }
    $pagination.= "...";
    $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
    }
    //in middle; hide some front and some back
    elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
    {
    $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    $pagination.= "...";
    for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class=\"current\">$counter</span>";
    else
    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
    }
    $pagination.= "...";
    $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
    $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
    }
    //close to end; only hide early pages
    else
    {
    $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
    $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
    $pagination.= "...";
    for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
    {
    if ($counter == $page)
    $pagination.= "<span class=\"current\">$counter</span>";
    else
    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
    }
    }
    }
       
    //next button
    if ($page < $counter - 1)
    $pagination.= "<a href=\"$targetpage?page=$next\"> next >></a>";
    else
    $pagination.= "<span class=\"disabled\"> next >></span>";
    $pagination.= "</div>\n";        
    }

                                       // End Pagination Code //
?>





























<?php
                             // Begin Resize Image To Specific Dimensions Code //

    
    $dir = "images/"; //dir of your images
    $exten1 = "jpg"; //extension -> jpg / gif / png
    $exten2 = "png"; //extension
    $exten3 = "gif"; //extension
    
    $maxwidth = '190'; //maximum width
    if ($handle = @opendir($dir)) 
    
    echo "<table>";
    echo "<tr>";
           
    {
    
    while (false !== ($file = @readdir($handle))) { 
    $bestand = $dir ."/". $file;
    $ext = pathinfo($bestand);
    if($ext['extension'] == $exten1 || $ext['extension'] == $exten2 || $ext['extension'] == $exten3)
    
    while($row = mysql_fetch_array($result)) {
    
    {
      
    $width = getimagesize($bestand);
    if($width[0]<$maxwidth)
    
    {
    
    /* 
    echo "<td align=\"center\">";
    echo "<a href=\"http://localhost/scripts/index.php?id=$row[$id]\"><img border=\"1\" src=\"images/$row[element_5]\" alt=\"$row[element_1]\" title=\"$row[element_1]\">";
    echo "<p />";
    echo "<a href=\"$row[element_2]\">$row[element_1]</a>";
    */
    
    }

    else

    {
    
    echo "<td align=\"center\">";
    echo "<img src=\"images/$row[element_5]\" border=\"1\" width='$maxwidth' alt=\"$row[element_1]\" title=\"$row[element_1]\">";
    echo "<p />";
    echo "<a href=\"$row[element_2]\">$row[element_1]</a>";
    

    } 
    }
    } 
    }
    @closedir($handle);
    } 
    
    echo "</tr>";
    echo "</td>";
    echo "</table>";
    
                             // End Resize Image To Specific Dimensions Code //

?>











<p />
&nbsp;
<p />

<div align="center">

<?=$pagination?></div>

</body>
</html>

Thank you

for "<table><tr>", must have "<td>".