Output table rows format question

[sks1024]

I have scripts that output data in seperate row for each record.

i.e.

$query = "SELECT * FROM table";




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

  print"<tr bgcolor=$color>";

           print"<td>$row['data'];</td>";

  print"</tr>";

}

how would you format the html to output this same data in say in table row with a limit of 5 records and then start a new table row.

i.e.

<tr>
     <td>Data</td><td>Data</td><td>Data</td><td>Data</td><td>Data</td>
</tr>

<tr>
     <td>Data</td><td>Data</td><td>Data</td><td>Data</td><td>Data</td>
</tr>

Thanks

[Houdini]

Just echo it that way;

echo"<tr><td>{$row['fieldname']}</td><td>{$row['fieldname']}</td>
<td>{$row['fieldname']}</td><td>{$row['fieldname']}</td>
<td>{$row['fieldname']}</td></tr>";

[madwormer2]

Lol, he wants

<tr>
     <td>Data1</td><td>Data2</td><td>Data3</td><td>Data4</td><td>Data5</td>
</tr>
<tr>
     <td>Data6</td><td>Data7</td><td>Data8</td><td>Data9</td><td>Data10</td>
</tr>

etc.

[sks1024]

madwormer2 is right.

any suggestions

[bradgrafelman]

Here's my guess. I'll test it later if I have time...

$query = 'SELECT `fieldName` FROM `myTable`'; // your query here, obviously
$exec = mysql_query($query) or die('MySQL Error: ' . mysql_error());
$data = array();

while($row = mysql_fetch_assoc($exec))
	$data[] = $row;

echo "<table>\n";

for($i=0,$col=1; isset($data[$i]); $i++,$col++) {
	if($col == 1)
		echo "<tr>\n";

if(isset($data[$i+1]))
	echo '<td>' . $data[$i]['fieldName'] . '</td>';
else {
	echo '<td>' . $data[$i]['fieldName'] . '</td>';

	while($col < 5) {
		echo "<td>&nbsp;</td>\n</tr>";
		$col++;
	}

	break;	
}

if($col == 5) {
	echo "\n</tr>\n";
	$col = 0;
}
}

echo '</table>';

EDIT: Okay, so it's broken somewhere, I'm debugging it ATM. Feel free to help 🙂

EDIT2: Found the bug. Code snippet above works for me, assuming you fill in the SQL information and whatnot. If you'd like an explanation of the different structures and logic involved (i.e. if you want to learn and become better 😉), feel free to ask about anything that looks foreign to you.

[rbblue8]

bradgrafelman wrote:

Here's my guess. I'll test it later if I have time...

$query = 'SELECT `fieldName` FROM `myTable`'; // your query here, obviously
$exec = mysql_query($query) or die('MySQL Error: ' . mysql_error());
$data = array();

while($row = mysql_fetch_assoc($exec))
	$data[] = $row;

echo "<table>\n";

for($i=0,$col=1; isset($data[$i]); $i++,$col++) {
	if($col == 1)
		echo "<tr>\n";

if(isset($data[$i+1]))
	echo '<td>' . $data[$i]['fieldName'] . '</td>';
else {
	echo '<td>' . $data[$i]['fieldName'] . '</td>';

	while($col < 5) {
		echo "<td>&nbsp;</td>\n</tr>";
		$col++;
	}

	break;	
}

if($col == 5) {
	echo "\n</tr>\n";
	$col = 0;
}
}

echo '</table>';

EDIT: Okay, so it's broken somewhere, I'm debugging it ATM. Feel free to help 🙂

EDIT2: Found the bug. Code snippet above works for me, assuming you fill in the SQL information and whatnot. If you'd like an explanation of the different structures and logic involved (i.e. if you want to learn and become better 😉), feel free to ask about anything that looks foreign to you.

This helped me as well 🙂 Only i needed to display a count next to the text it was pulling... so i added a few things to do so (mostly a query for the count).

	//lets have some fun with a while statment
	while($result=mysql_fetch_assoc($query))$data[] = $result;

echo '<table border="1" align="center" width="30%">';

for($i=0,$col=1; isset($data[$i]); $i++,$col++) 
	{
	if($col == 1)
    	echo "<tr>\n";

		//give a count of how many users are in the city
		$city=$data[$i]['citys'];
		$string1=("SELECT city FROM profile WHERE city='$city'");
		$query1=mysql_query($string1, $db) or $error='<center id="error">Error while getting a list of users in a city <br />'.mysql_error().'</center>';
		$count=mysql_num_rows($query1);

		if(isset($data[$i+1]))
    	echo '<td><center>'.$data[$i]['citys'].'('.$count.')</center></td>';
		else {
    		  echo '<td><center>'.$data[$i]['citys'].'('.$count.')</center></td>'; 
   			  break;    
			}

		if($col == 2)
		{
    	echo "</tr>";
   		 $col = 0;
		}
	}

echo '</table>';

[m_tt]

Maybe this will give you an idea 🙂

$query = mysql_query("SELECT * FROM `table`");

$col = 1;
$output = "<table><tr>";

while($result = mysql_fetch_assoc($query))	{
	$output .= "<td>{$result['field']}</td>";

if ($col % 5 == 0)	{
	$output .= "</tr><tr>";
	$col = 0;
}

$col++;
}

$output .= "</tr></table>";

echo $output;