having a table in while loop

[Anon]

dear PHPers here is my code, and my question is how can i put the results into a nice table with 3/4 sells.

<?
include("config.php");
include("functions.php");

$id="6";
$home="<a href=/>Home</a>";

$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");

$query = "SELECT DISTINCT cat_id, name, mas_cat_id from ds_categories WHERE ds_categories.mas_cat_id='$id'";
$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());

echo "<table width=500 align=center><tr><td>";

while(list($cat_id, $name, $mas_cat_id) = mysql_fetch_row($result))
{
$catlist="<a href=/index.php3?catstr=$cat_id>$name</a> | ";

echo "$catlist";

}

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

mysql_close($connection);
?>

[amcgrath]

Well, you kinda already did it... just add your tr's and td's up there where you echo $catlist....

[kamurj]

First of all, thank you very much for resoponding, that was a helpful hint, but that will put each records inside <tr><td>record</td></tr> etc.

I want to have a table with 3/4 records on each line. if you know how can i do this please help.

thank you very much again.

[amcgrath]

OK, well, then how aobut this:
echo "<table width=500 align=center><tr><td>";

$tick = 1;
while(list($cat_id, $name, $mas_cat_id) = mysql_fetch_row($result))
{
$catlist="<a href=/index.php3?catstr=$cat_id>$name</a> | ";

echo "$catlist";
if ($tick % 3 == 0) { // change this to 4 if you want 4 rows in the same row
echo "</td></tr><tr><td>";
}
$tick++;
}

[kamurj]

Allen, perfect!
your code just did what i wanted, thank you very very much

[amcgrath]

No problem, I just hope you understand what it's doing so you can pass the kowledge along.

[kamurj]

alen, i carefully looked at html and it puts 3 records in one row. ex. <tr><td>record1 record 2 record3</td></tr> etc.

how can i have one record for each cell and three cells on each row. please, tell me if this can be accomplished.

thanks
arman

[kamurj]

ok, i did that. thanks!
arman