Need help displaying 'while' results..thanks

[VenusJ]

Hello everyone,
I have a while loop that join 2 tables, here is my code:

<?php
$result = mysql_query("SELECT m.model, COUNT(g.modelids) AS model_rows
                       FROM models m LEFT JOIN model_groups g ON m.modelid = g.modelids
                       GROUP BY m.model ORDER BY m.model;",$link);
while ($a_row =mysql_fetch_array ($result) )
{

print "$a_row[model] ($a_row[model_rows])<br>";


}
?>

I have 60 records in models table, and it currently prints out 60 results perfectly on the page in one column. ex.

angle (6)
benny (8)
sexy (3)
blah (2)
benny (8)

blah (8)

blah (9)

sexy (3)

blah (9)

blah (8)

.....and so on

Now i was hoping to print out 3 columns on the page horizontally like:

angle (6) blah (2) blah (2)
benny (8) blah (8) blah (9)

sexy (3) blah (9) blah (8)

How do i do that? is there a way to do it in PHP? thank you for your help.

[khaldryck]

<?php 
$i=0;
$result = mysql_query("SELECT m.model, COUNT(g.modelids) AS model_rows 
                       FROM models m LEFT JOIN model_groups g ON m.modelid = g.modelids 
                       GROUP BY m.model ORDER BY m.model;",$link); 
while ($a_row =mysql_fetch_array ($result) ) 
{ 
print "$a_row[model] ($a_row[model_rows])"; 
if(!(++$i%3)) print "<br>" else print "&nbsp;"


} 
?> 

[VenusJ]

Hello,
thank you. You've got my idea right, but this is not what I was after actually. i was hoping to line it line with a table instead of printing it out like this:

ann(0) blah(0) blah (0)
annblah(0) blah(0) blahblah (0)
ann(0) blah(0) blahblah (0)
ann(0) blahblah(0) blahblah (0)
annblah(0) blah(0) blah (0)
ann(0) blah(0) blahblahblah (0)
ann(0) blah(0) blahblah (0)

But you have given me clue, and I will try to work it out at the same time, if you have a better solution, pls let me know.

thanks!

[khaldryck]

<?php  

print "<table>";
$i=0; 
$result = mysql_query("SELECT m.model, COUNT(g.modelids) AS model_rows 
                       FROM models m LEFT JOIN model_groups g ON m.modelid = g.modelids 
                       GROUP BY m.model ORDER BY m.model;",$link);  

while ($a_row =mysql_fetch_array ($result) )  

{  

if(($i%3)==1) print "<tr>"; 

print "<td>$a_row[model] ($a_row[model_rows])</td>";  

if(!(++$i%3)) print "</tr>";

}
if(($i%3)==1) print "<td></td><td></td></tr>"; 
elseif(($i%3)==2) print "<td></td></tr>"; 
print "</table>";
?> 

That's more the idea of what you want.
Lemme explain a bit :
you increment a $i to know the position of the record.
if i%3 == 1 -> it's the first cols, so you need to start a <tr>
if i%3 == 0 -> it's the last one, so you need to close the </tr>

when the loop is finished, you need to know if the last <tr> was closed as well
if i%3 == 1 -> only one cols was made -> need to make 2 more cols and close the >/tr>
if i%3 == 2 -> only 2 cols were made -> need to make 1 more col and close the >/tr>
else the tr was closed correctly

[VenusJ]

hello,
beautiful, that works 😃
but this code:
if(($i%3)==1) print "<tr>";

should've been after $i=0; instead of in the while bracket

<?php   

print "<table>"; 
$i=0;
if(($i%3)==1) print "<tr>";   

$result = mysql_query("SELECT m.model, COUNT(g.modelids) AS model_rows 
                       FROM models m LEFT JOIN model_groups g ON m.modelid = g.modelids 
                       GROUP BY m.model ORDER BY m.model;",$link);   

while ($a_row =mysql_fetch_array ($result) )   

{   

print "<td>$a_row[model] ($a_row[model_rows])</td>";   

if(!(++$i%3)) print "</tr>"; 

} 
if(($i%3)==2) print "<td></td><td></td></tr>";  

elseif(($i%3)==2) print "<td></td></tr>";  

print "</table>"; 
?>

thanks khaldryck
appreciated for your patient and helps..

[khaldryck]

yeah maybe, i just wrote the code without thinking a lot about it.

Well i'm glad that you got what you wanted.

Mark this thread resolved, it will help everyone when browsing the threads 🙂

[raouleduke]

I kind of get what you are doing I want to do the exact same thing, but with records. And display them two wide and as many down as there is:
12
34
56
78
etc...
I have the table but need to know where to put the rest of the stuff.

 <?php
				mysql_connect(""); 
				mysql_select_db("");  

                $query = "SELECT * FROM fmmedia WHERE CATEGORY LIKE '$category' OR CATEGORY1 LIKE '$category' OR CATEGORY2 LIKE '$category' OR CATEGORY3 LIKE '$category' ";
				$result = mysql_query($query);
				while ($row = mysql_fetch_array($result)){
				$subsite = $row["subsite"];
				print "<table width='225' border='0' cellspacing='0' cellpadding='0'>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'><strong>{$row["name"]}</strong></font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["address"]}</font></div></td>
                    </tr>
                    <tr>
                      <td><table width='225' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td width='89'><div align='right'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["city"]}</font></div></td>
                            <td width='41'><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["state"]}</font></div></td>
                      		<td width='95'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["zip"]}</font></td>
                          </tr>
                        </table></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["phone"]}</font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='subsite/". $subsite . "/index.php'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Business Profile</font></a></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='{$row["website"]}'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Website</font></a></div></td>
                    </tr>
					<tr>
                      <td height='18'></td>
                    </tr>
                  </table>\n";
				 }
				 ?> 

Thanks in advance for your help.