display results in pairs

[fumanshu]

hmm..no idea how to solve this one...

I'm returning results from a php/mysql query. I normally display all results in rows - one result per row:

XX

XX

XX

etc

how can i display, say 2 sets of results per row eg.

XX ----- XX
XX ----- XX

Any ideas?

[stolzyboy]

check out this thread, seams to be the same question

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10225708

[DigitalExpl0it]

hope this helps

<?
  //Start loop for more than column out put
$i = 1;
?>
                      <tr> 
<?
// Loop for database connection, lets get the records
	while ($row = mysql_fetch_array($sql_result)){
		$rs_fld1 = $row["pname"];
// How many columns on output (Default set to 2)
	if ($i == 2) {
	   $i = 1;
?>
                      </tr>
                      <tr> 
<? } ?>
                        <td align="center" valign="middle" width="100%"> 
						<? echo $rs_fld1; ?>
                        </td>
<?
// loop
	 $i++;
	}
?>
                      </tr>
                    </table>
 <?
//Start the Echo out from databse records to html output -----End------
?>

[fumanshu]

errr....Here's my code - adapted from yours - doesn't look right..:

echo "<tr>";
// *** iterate through resultset
$i = 1;
while($row = mysql_fetch_object($result))
{
$rs_fld1 = $row->name;
// How many columns on output (Default set to 2)
if ($i == 2)

                            {
   		$i = 1;
                 	echo "</tr>";
                 	echo "<tr>";
	}

echo "<td align=center valign=middle width=100%>";
echo $rs_fld1; 
echo "</td>";
// loop
   	$i++;
   	}

echo "</tr>";
echo "</table>";
echo "</p>";

any more advise?

[stolzyboy]

did you try the one i wrote for the other thread??? it worked just fine for him

[fumanshu]

oops - didn't see that - he seemed happy - I'll give it a go - thanx