Showing 5 results....

[last_trace]

I want to display values from my database, I can call and display the information but..

I need to display 5 values per row and then have it start a new line, etc.

Foreach/For loop maybe? Not to comfortable with them.

[JP128]

you can use a nested loop...

but I am not very sure how to do it with PHP... lol, In my school's java class I can.. but they have stuff to do that.. I would actually like to know how to do this as well.

[JP128]

[url=http://www.php-mysql-tutorial.com/examples/source/paging/paging3.phps]http://www.php-mysql-tutorial.com/examples/source/paging/paging3.phps[/url]

You can look there at a sample script...

and here for the tutorial...

[url=http://www.php-mysql-tutorial.com/php-mysql-paging.php]http://www.php-mysql-tutorial.com/php-mysql-paging.php[/url]

[last_trace]

Actually i didn't want a pagination

i want
ex":

result 1 | result 2 | result 3 | result 4 | result 5(<br />)
result 6 | result 7 | result 8 | result 9 | result 10(<br />)

[JP128]

oh ... i see.
Here is what I came up with.
[code]<?php
//Connect to the Database
$i = 1;
$sql = mysql_query ("SELECT column_name FROM `table_name`");
while($row = mysql_fetch_assoc($sql)){
echo $row['column'] . " | ";
if($i == 5){
echo "<BR>";
$i = 0;
}
$i = $i + 1;
}
?>
[/code]

[The Little Guy]

Something like this could work:
[CODE]<?php
$number_rows = 1000;    #You may need to change this. Chance to your liking.
$number_columns = 5;    #same with this. Chance to your liking.
for($r=1;$r<$number_rows;$r++){
    echo'<tr>';
    for($c=1;$c<$number_columns;c++){
          $row = mysql_fetch_array($row);
          if(!$row){
              break;
          }
          echo'<td>'.$row['field_name'].'</td>';
    }
    echo'</tr>';
}
?>[/CODE]