two column results using PHP/MySql

[blanius]

We use Dreamweaver for most of our database retrieval but I'm tying to do a two colum layout of data.... Right now the table has 6 entries so I'd want two columns of 3 each. I can't seem to figure out how to do it without quering the database a second time which I'd rather not do.

How would one go about this?

[craigh]

need more information. What is the table structure? Are you wishing to take 6 result rows and display them in two columns or do you have 3 result rows with two columns that you wish to display?

[blanius]

Sorry it's such a simple table, just a links table name,description, and URL that's it.... What I'd really like to do is split it up in two or three rows.

[craigh]

OK - well, first you need to stick the results into an array:

pseudo-code:

myarray=array();
$j=1;
while (next-record-loop)
{
myarray+=array($j=>array('name'=>name, 'desc'=>description, 'ur;'=>url));
$j++;
}

then you can display them however you want (pseudo-code):

echo "<TABLE>";
$records=count($myarray);
reset ($myarray);
for ($i=1, $i<=$records; $i+2)
{
echo "<TR><TD>".$myarray[$i]['name']."</TD><TD>".$myarray[$i+1]['name']."</TD></TR>";
}

this should print something like:

name1 name2
name3 name4
name5 name6
etc...

Of course, if you want to include more information, you can modify the echo line.

I haven't tested any of this, but that should be close.

[blanius]

Thanks, this is kind of where I had been going. Just seemed redundant, isn't a query result already in an array?

[craigh]

not completely sure, I think it is an object.

[blanius]

Just thought I'd share the solution I finally wound up with:

<table bgcolor="#C9C994">

<?php 


for($loop=0;$loop<$totalRows_Recordset1/3;$loop++){

?>
      <tr>
        <td width="234" height="38" valign="top">
        <a href="<?php echo $row_Recordset1['url']; ?>"><strong><?php echo $row_Recordset1['name']; ?></strong></a><br>

          <em><?php echo $row_Recordset1['description']; ?></em>
      </td>
      <?php $row_Recordset1 = mysql_fetch_assoc($Recordset1);?>
    <td width="267" valign="top"><a href="<?php echo $row_Recordset1['url']; ?>"><strong><?php echo $row_Recordset1['name']; ?></strong></a><br>
        <em><?php echo $row_Recordset1['description']; ?> </em>	     </td>
     <td width="2">&nbsp;</td>
     <?php $row_Recordset1 = mysql_fetch_assoc($Recordset1);?>
	   <td width="267" valign="top"><a href="<?php echo $row_Recordset1['url']; ?>"><strong><?php echo $row_Recordset1['name']; ?></strong></a><br>
        <em><?php echo $row_Recordset1['description']; ?> </em>	     </td>
     <td width="200">&nbsp;</td>
     <?php $row_Recordset1 = mysql_fetch_assoc($Recordset1);?>
  </tr>
 <?php
 } ?>
      </table>