Help! pulling my hair out ...

[Sean S]

Today I found out that I'm still a noob when it comes down to php :ermm: and would like to ask for help here once again, and I hope someone will be able to do so.

Goal:
what I'm trying to do is to display some data from mysql in a php page in a table containing 3 columns.

Problem:
I can't get the code to work and display the data in columns. I already know how to display the data in rows using the loop, but what I don't know is how I would go ahead and display the data in columns.

So instead of having something like this,

data 1
data 2
data 3

I want to have something like this

data 1 data 2 data 3

The code that I'm working with is the following, and it just doesn't work for me,

PHP Code:

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

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

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

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

$getbikes = mysql_query("SELECT * FROM $table ORDER BY id DESC LIMIT $number "); //Retrieves all of the Data from table
while($row = mysql_fetch_assoc($getbikes))
{
echo "<table><tr>";

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 == '$pp_column') { 

        echo "</td></tr><tr>";
        
$column = $col_value*$e;
$e++;
} 

else     {
    echo "</td>";
    }
    
$i++;
}

echo "</tr></table>";       
?>

thanks in advance :nervous: ,
Sean