keep two column format in a while statement?

__greg

im trying to execute a while statement where the information is displayed in two columns no matter what. i will probably have a lot of information from the while statement, but i still want to keep the two column structure..

here's the code im using, but it doesnt seem to be working correctly:

while ($row = mysql_fetch_array($get_data)) {
$id = $row['id'];
$text = $row['text'];

list($width, $height, $type, $attr) = getimagesize("images/images/thumbs/".$row['image']."");
$image = "<img src='images/images/thumbs/".$row['image']."' $attr style='{border: solid #000000 1px}' alt='' />";


		$display_block .= "	<tr>
								<td width='45%'>
									$image
									<span class='big'><a href='?id=$id'>$text</a></span>
								</td>
								<td width='10%'></td>
								<td width='45%'>
									$image
									<span class='big'><a href='?id=$id'>$text</a></span>
								</td>
							</tr>

}

it retrieves the data fine, but it isn't in the format im looking for... i want it to be displayed like:

a b
c d
e f
g h
...

and on and on depending on how much data is retrieved

bastien

it looks like there is supposed to be one image with each record pairing. Is this correct?

If so, try placing the image in the table as well

__greg

yes that is correct, there is one image with each record.. what do you mean place the image within the table?

it is within the td tag, which is within the table

bastien

sorry, my bad. Didn't notice that.

edit
I figured out what it is that is wrong and what you are looking for (note to self: stop doing this at midnight)

What you need to do is place an if/then and a counter inside the loop to manage the two columns:


[color=red]$x=1; //counter[/color]

while ($row = mysql_fetch_array($get_data)) { 
$id = $row['id']; 
$text = $row['text']; 

list($width, $height, $type, $attr) = getimagesize("images/images/thumbs/".$row['image'].""); 
$image = "<img src='images/images/thumbs/".$row['image']."' $attr style='{border: solid #000000 1px}' alt='' />"; 

  [color=red]           

  if ($x==1){
            $display_block .= " <tr> ";
  }[/color]

        $display_block .= " 
                                <td width='45%'> 
                                    $image 
                                    <span class='big'><a href='?id=$id'>$text</a></span> 
                                </td> 
                                <td width='10%'></td> 
                                <td width='45%'> 
                                    $image 
                                    <span class='big'><a href='?id=$id'>$text</a></span> 
                                </td>";

[color=red]
   //increase the counter by 1
   $x++;


  if ($x==1){
            $display_block .= " </tr> ";
            [b]//reset the counter
           $x=1;[/b]
  }    

   [/color]                        

}