new table row

[corillo181]

so i want a new row to be inserted after every 3 records i have a table in mysql with 100 username i want 3 names per row..

 

i know is with a for loop with a reminder % but i totaly forgot.

[cooldude832]

give us your code first and i'll patch it in

[corillo181]

alright this i know does not work at all, but is the bits of peaces that i remember..

 

<table width="100%" border="1"><tr>
<?php
$select=mysql_query("SELECT username FROM members");
$count=mysql_num_rows($select);
$limit=3;
for($i=$limit%$count;$i>=$limit;$i++){
while($username=mysql_fetch_array['username']){
echo '<td>'.$username.'</td>';
}

echo  '</tr>';}
}
?> 
</table>

[pocobueno1388]

You could do it with a few different methods. You could do something like this:

 

<?php

$query = mysql_query("SELECT username FROM users WHERE condition");

$counter = 0;
while ($row = mysql_fetch_assoc($query)){
   echo $row['username'] .' ';

   if ($counter == 3){
      echo '<br>';
      $counter = 0;
   }

$counter++;
}

?>

[corillo181]

i don't think that will help my table problem :S

[cooldude832]

Try this

 

alright this i know does not work at all, but is the bits of peaces that i remember..

 

<table width="100%" border="1"><tr>
<?php
$select=mysql_query("SELECT username FROM members");
$limit = 3;
$i = 0;
while($username=mysql_fetch_array['username'])
{
if ($i%$limit == 0)
{echo "</tr><tr>";}
$i++;
echo '<td>'.$username.'</td>';
}
?> 
</table>

 

should work

[corillo181]

EXACTLY!!!!!!!!!!!!!

COOL DUDE YOU ARE A COOL DUDE, BEEN HELP ME THREW ALL MY PROBLEMS

[corillo181]

it works fine but it has a invalid html formatting

 

<table width="100%" border="1"><tr>

</tr><tr><td>Jay</td><td>juan</td><td>12</td></tr><tr><td>jack</td><td>jhon</td><td>gorge</td>

</table>

[cooldude832]

after it gets done run add </tr> it will always need a </tr> so no worries there

[corillo181]

i try that, but it still makes a empty row the first one.

<tr></tr>

[cooldude832]

if ($i%$limit == 0)

 

change to

if ($i%$limit == 0 && $i >0)

 

[teng84]

it works fine but it has a invalid html formatting

 

<table width="100%" border="1"><tr>

</tr><tr><td>Jay</td><td>juan</td><td>12</td></tr><tr><td>jack</td><td>jhon</td><td>gorge</td>

</table>

 

those <td></td> are outside tr

<tr>

 

<td>

</td>

 

</tr>

 

try doing it that way

 

hope that helps