DaniWeb Forum Index > Web Development > PHP

How to show more than one result in while loop

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2009

Posts: 83

Reputation: nish123 is an unknown quantity at this point

Solved Threads: 0

nish123

Offline

Junior Poster in Training

How to show more than one result in while loop

Sep 29th, 2009

hello friends..

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?while($row=(mysql_fetch_array(result))
{?>
   <tr>
       <td><?echo $row['photo']?></td>
       <td><?echo $row['info']?></td>
</tr>
<?}?>
<?while($row=(mysql_fetch_array(result))
{?>
   <tr>
       <td><?echo $row['photo']?></td>
       <td><?echo $row['info']?></td>
</tr>
<?}?>

above code i use for fetching data.. one result in one row at a time..!!!

now i m try to show two result in one row..!!!
in other words.. two different data in one row..!!!
how can i do that...???

Last edited by nish123; Sep 29th, 2009 at 1:06 pm.

•

Join Date: Sep 2008

Posts: 214

Reputation: chrishea is an unknown quantity at this point

Solved Threads: 32

chrishea

Offline

Posting Whiz in Training

Re: How to show more than one result in while loop

Sep 29th, 2009

How about:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?PHP
while($row=(mysql_fetch_array(result)) {
 
   echo "       
   <td>$row['photo']</td><td>$row['info']</td>
         ";
   if ($row=(mysql_fetch_array(result)) {
      echo "
      <td>$row['photo']</td><td>$row['info']</td>
      ";
   }
 
   echo "</tr>";
}
 
?>
<?PHP
while($row=(mysql_fetch_array(result)) {

   echo "       
   <td>$row['photo']</td><td>$row['info']</td>
         ";
   if ($row=(mysql_fetch_array(result)) {
      echo "
      <td>$row['photo']</td><td>$row['info']</td>
      ";
   }

   echo "</tr>";
}

?>

I find it messy to go in and out of PHP so I modified it to make it all PHP.

Last edited by chrishea; Sep 29th, 2009 at 3:34 pm.

Chris
See my list of PHP development tools at:
InnovationsDesign.net

•

Join Date: Apr 2005

Posts: 1,403

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 225

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Re: How to show more than one result in while loop

Sep 29th, 2009

•

Originally Posted by chrishea

How about:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
<?PHP
while($row=(mysql_fetch_array(result)) {
 
   echo "       
   <td>$row['photo']</td><td>$row['info']</td>
         ";
   if ($row=(mysql_fetch_array(result)) {
      echo "
      <td>$row['photo']</td><td>$row['info']</td>
      ";
   }
 
   echo "</tr>";
}
 
?>
<?PHP while($row=(mysql_fetch_array(result)) { echo " <td>$row['photo']</td><td>$row['info']</td> "; if ($row=(mysql_fetch_array(result)) { echo " <td>$row['photo']</td><td>$row['info']</td> "; } echo "</tr>"; } ?>
I find it messy to go in and out of PHP so I modified it to make it all PHP.

Just no. For two reasons: Reason 1) You're duplicating code, if he wants to change the td's to dd's or something like that he has to change it in two places, Reason 2) I'm not even going to begin with how much more ugly that looks when compared to exiting PHP

The best way to go about it is to keep a counter and whenever it's divisible by 2 you've looped twice so end the row and start another one.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<tr>
<?php $i = 1; while($row=mysql_fetch_array(result)): ?>
  <?php if (!($i++ % 2) ): ?>
    </tr><tr>
  <?php endif ?>
    <td><?php echo $row['photo'] ?></td>
    <td><?php echo $row['info'] ?></td>
<?php endwhile ?>
</tr>
<tr>
<?php $i = 1; while($row=mysql_fetch_array(result)): ?>
  <?php if (!($i++ % 2) ): ?>
    </tr><tr>
  <?php endif ?>
    <td><?php echo $row['photo'] ?></td>
    <td><?php echo $row['info'] ?></td>
<?php endwhile ?>
</tr>

Last edited by ShawnCplus; Sep 29th, 2009 at 5:28 pm.

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.

•

Join Date: Jul 2009

Posts: 210

Reputation: CFROG is an unknown quantity at this point

Solved Threads: 14

CFROG

Offline

Posting Whiz in Training

Re: How to show more than one result in while loop

Sep 29th, 2009

This may be a worth while solution ...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$i = 0; 
$num_of_cols = 5; 
echo "<table cellspacing=\"10\" cellpadding=\"10\"><tr>"; 
while($row=(mysql_fetch_array(result)) {
echo ($i!= 0 && $i%$num_of_cols == 0)?'</tr><tr>':''; 
echo "<td valign=\"bottom\" align=\"center\">";
echo "<Your_output_here>";
echo"</td>"; 
$i++; }
echo '</tr></table>';
$i = 0; 
$num_of_cols = 5; 
echo "<table cellspacing=\"10\" cellpadding=\"10\"><tr>"; 
while($row=(mysql_fetch_array(result)) {
echo ($i!= 0 && $i%$num_of_cols == 0)?'</tr><tr>':''; 
echo "<td valign=\"bottom\" align=\"center\">";
echo "<Your_output_here>";
echo"</td>"; 
$i++; }
echo '</tr></table>';

You can change the number if columns to whatever you want and it will simply start a new row when you reach that number of columns. Adjust the cellspacing, cellpadding, and aligns accordingly. Just a thought.