how do you display three records then start a new row?

[DrewM]

Originally Posted by Sean S

Ok I'm no php professional, but this is what I did once for a client of mine and it seemed to work. Basically it displays the results upto 3 columns per row or 3 results per row, once the 3 results has been displayed, it goes to the next row.

$number, this variable controls the total amount of data you want to display.

also you have to change this part

SELECT id, image, link, category FROM $table

to whatever your table is setup to.

and last, change this the same way,

$row[link]

PHP Code:

<?php
$username="database_username";
$password="database_password";
$database="database_name";
$table="table_name"; //the sql table name that you want to pull out the data from
$number="6"; //the total amount of results that you want to display

$i = 1;
$e = 2;

//number of columns of the table generated
$column = 3;

//connecting to mysql
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); 

$getresults = mysql_query("
    SELECT id, image, link, category FROM $table  
    ORDER BY id ASC
    LIMIT $number");
    
echo "<table><tr>";
while($row = mysql_fetch_array($getresults))
{
echo "<td>";

echo "<p>$row[link]</p>";
       
echo "</td>";

if ($i == $column) {

echo "</tr><tr>"; 

$column = 3*$e;

$e++;

}  
    
$i++;

}

echo "</table>";    

?> 
<br />

hope this helps

how can this be done with vb?