[SOLVED] How to make table's columns?

[ayok]

Hi,

I have some pictures in database and I want to show it on my webpage. The problem is, I want to make those pictures are shown on a table with 3 or 5 columns before new rows.

 

For example, I insert this code

	
<?php 
while ($data = mysql_fetch_array($show){
echo"<table>
echo"<tr><td><img src='$url/thumbnails/$data[image]'></td></tr></table>";

to show the pictures from database, the pictures will be shown vertically with only one columns. Could anybody tell me how to get some columns before new row? I hope you understand my question. I have no idea how to find the keywords for googling.

 

thanks,

ayok

[Barand]

sample code

<?php
include 'db.php';

define ("NUMCOLS",5);

$res = mysql_query("SELECT col1, col2 FROM mytable");

$count = 0;
echo "<TABLE border=1>";
while (list($col1, $col2) = mysql_fetch_row($res)) {

    if ($count % NUMCOLS == 0) echo "<TR>\n";  # new row

    echo "<TD>$col1<br>$col2</TD>\n";
    $count++;

    if ($count % NUMCOLS == 0) echo "</TR>\n";  # end row
}

# end row if not already ended

if ($count % NUMCOLS != 0) {
   while ($count++ % NUMCOLS) echo "<td> </td>";
   echo "</TR>\n";
}
echo "</TABLE>";

?>

[ayok]

Hey Barand, thanks!

It works perfectly.

 

cheers,

ayok