Ad:

PHP Discussion Thread
Unsolved
Views: 893

Sep 29th, 2009

How to show more than one result in while loop

Expand Post »

hello friends..

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.

Similar Threads

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP
help in stored procedure-result of a loop using cursor in MS SQL
Result without while loop in PHP
Visual Basic Help! in Visual Basic 4 / 5 / 6
recognize end of pps show by visual basic in Visual Basic 4 / 5 / 6

nish123

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

83 posts
since Apr 2009

Permalink

Sep 29th, 2009

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

How about:

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.

chrishea

Reputation Points: 210

Solved Threads: 228

Nearly a Posting Virtuoso

Offline

1,389 posts
since Sep 2008

Permalink

Sep 29th, 2009

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

Click to Expand / Collapse Quote originally posted by chrishea ...

How about:
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.

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.

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

Permalink

Sep 29th, 2009

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

This may be a worth while solution ...

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.

CFROG

Reputation Points: 21

Solved Threads: 31

Posting Pro in Training

Offline

405 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Help me convert this ASP into PHP plz :-)

Next Thread in PHP Forum Timeline: Show region behavior for a php generated txt box

DaniWeb Message

Cancel Changes

User Name
Password