CodingForums.com - Need Help with database Queries in HTML tables

CodingForums.com (http://www.codingforums.com/index.php)

- MySQL (http://www.codingforums.com/forumdisplay.php?f=7)

- - Need Help with database Queries in HTML tables (http://www.codingforums.com/showthread.php?t=274016)

Need Help with database Queries in HTML tables

Hi,

I having problems displaying queries from a mySQL database. I want to display images and descriptions in a html table four columns wide.

so far I cam up with this.

PHP Code:


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

$entry_name = $row['entry_name'];

$entry_submition = $row['entry_filename'];

$entry_pic = '<div class="display-img"> <img src="../photos/'.$row['entry_filename'].'"></div>';

$count=4;

echo "<table>";

  

   echo '<tr>';

   for ($counter=0; $counter <$count; $counter++){

        echo '<td>'.$entry_name.'<br>'.$entry_pic.'<td>';

   } 

  echo '</tr>';

echo "</table>";

}

This displays the table correctly, but it shows each item four times in each row.

What I need it to show each item once.

If any one can help. That would be great

PHP Code:


		
			
$count = 0;

echo "<table>\n";

while ($row = mysql_fetch_array( $result ))

{

    if ( $count == 0 ) { echo "<tr>\n"; }

    $entry_name = $row['entry_name'];

    $entry_submition = $row['entry_filename'];

    $entry_pic = '<div class="display-img"> <img src="../photos/'.$row['entry_filename'].'"></div>';



    echo '<td>'.$entry_name.'<br>'.$entry_pic.'<td>\n';



    ++$count;

    if ( $count == 4 ) 

    {

        echo "</tr>\n";

        $count = 0;

    }

}

echo "</table>\n";

Untested. I don't use PHP. But I use this technique with other languages and it works.