need help in PHP MYSQL reporting?

Question

I have a mysql table of tablename names with two fields ID and NAME. I have so many entries in that table, I want to display three names in one line.

example:

name1-name2-name3
name4-name5-name6
name7-name8-name9
and more....

anybody can give idea?

Answer 1

sql statement - "SELECT name FROM table"

//run the sql statement, changes if you are using PDO or another abstraction layer (recommended)
$count=0;
while($rs = fetchRow()){
if($count > 0){echo " - ";}
echo $rs['name'];
if($count==2){
echo "
";
$count=0;
}
}
?>

Answer 2

$count = 0;
while(++$count%3)
while(fetch data here)
echo here ;