[Sean S]

Originally Posted by princeton

if all you want is a 3 column (will never change)

echo <table>
while (loop)
{
echo <tr><td>col 1</td><td>col 2</td><td>col 3</td></tr>
}
echo </table>

wow thanks, those help me get a bit closer . Princeton the problem is that I might change the value sometimes, and I want to control the amount of columns by just changing a value of a variable, in this case the $column.

Using your code superfly also did help, I changed it around a bit and got this. However the problem with this one is that the number of columns only applies to the first row,

so I end up having data like this,

data 1 data 2 data 3
data 4 data 5 data 6 dtat 7 data 8 ....

I just can't understand why the value 3 for columns only applies to the first row now , you guys know why this happens? this is the final code that I have,

PHP Code:

<?php
$username="xxxxx";
$password="xxxxx";
$database="xxxxx";
$table="testing";
$number="8"; 

$i = "1";
$e = "2"; 
$col_value = "$column";

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

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

$getbikes = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT $number"); //Retrieves all of the Data from table
echo "<table><tr>";
while($row = mysql_fetch_assoc($getbikes))
{
echo "<td><a href='http://baldjf.com' class=''>$row[bikename]</a>";

echo "<a href='http://www.static-design.com'>";

echo "<img border='0' height='65'width='75' src='$filepath'>";
        
echo "<span>";
       
echo "<br>something here<br>";

echo "</a><br></font><br>";
   
echo "</span>"; 

if ($i == "$column") {

        echo "</td></tr><tr>"; 

$column = $col_value*$e;

$e++;
  
}  

else     { 

echo "</td>";

}
    
$i++;

}

echo "</table>";    

?>