mysql &gt; multi column output how

mysql > multi column output how

Matt_Parsons

I want to be able to extract data from a mysql table.
I want it displayed in x amount of columns, say 3.
How can i do this. I want to be able to change the amount of columns easily, by just changing one variable if possible.

thanks
Matt

mad27

SELECT column1, column2, column3 FROM table1, table2 WHERE <where-clause>

Basic (My)SQL syntax I'd say. Maybe read a book on using MySQL with PHP?

Matt_Parsons

I have found this code on the internet but cant think how to adapt it to do 3 columns or more any ideas:

$count = 1;
$column = 1;

//db connect and select

$result=mysql_query ("select * from players WHERE category='$category'");

while ($myrow = mysql_fetch_array ($result))
{
if ($column == 1)
{
printf("<tr><td width=250>%s</td>",$myrow[playername]);
}

else
{
printf("<td width=250>%s</td></tr>",$myrow[playername]);
}

$count += 1;
$column = $count % 2;
}

mad27

I think there you only have to changes the % 2 to % 3 or a higher number. the % is the modulo function.

tomhath

It will take a little more tweaking, but not much. I did not test what follows:

echo "<table>";
$displaycols = 3 // this really should be declared as a constant!
$column = 0;
while ($myrow = mysql_fetch_array ($result)) 
{ 
  if ($column == 0) { 
    printf("<tr>");
  }

  printf("<td width=250>%s</td>",$myrow[playername]);  

  $column++;  

  if ($column == $displaycols) { 
    printf("</tr>"); 
    $column=0;  

  } 
}
if ($column != 0) { 
  printf("</tr>"); 
}
echo "</table>";

Matt_Parsons

Thanks for the help.
The answer was staring me in the face really.
Matt