Add a </tr> <tr> during a php query

[monion]

All,
One more question (never ending right???)

If I have a list of names to pull from (Mitch, Bob, Randy, Simon, Paul & Will)
in a MYSQL database. How can I query them into a web page using select * from XXXXXX and display them 3 per line?

Ex:
Mitch Bob Randy (on one line)
Simon Paul Will (on the next) and so on and so on?

I can only seem to list them vertically top down, not conditionally across on multiple lines.

Thanks in advance,
MO

[ssnaik84]

well... it depends upon your style of coding.. simplest is..

$sql = "SELECT * FROM tablename";
$result = mysql_query($sql);

$i=0;
echo "<table><tr>";

while ($row = mysql_fetch_assoc($result)) {

   if($i < 3)
    {
      $i++;
      echo "<td>".$row["columname"]."</td>";
    }
   else
    {
       $i = 0;
       echo "</tr><tr>";
    }
}

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

[Dormilich]

well... it depends upon your style of coding.. simplest is..

I can imagine something even simpler… if you get the complete result set as array, it’ll be a piece of cake.

[Atli]

Hey.

Consider this:

echo "<table><tr>";
for($i = 0; $row = mysql_fetch_assoc($result); ++$i)
{
	if($i % 3 == 0 && $i != 0) 
	{
		echo "</tr><tr>";
	}
	echo "<td>{$row['item']}</td>";
}
for(; $i % 3 != 0; ++$i) 
{
	echo "<td>&nbsp;</td>";
}
echo "</tr></table>";

Check out the for loop, and Arithmetic Operators in the manual.

[Markus]

I had this issue once, and our once active expert pbmods gave an elegant solution: http://bytes.com/topic/php/answers/7...ple-strings-tr