[Resolved] Displaying results in columns

PoohStix

Hi there,

I am trying to display the contects of one of my mysql tables on one page but in two columns, but for some reason just cannot get my head around the logic of the php coding. The code I have so far that works is as below, what do I need to add/change to get it to display in two columns.

<table>
[code=php]
<?php

$conn = mysql_connect("localhost","root","password")
or die(mysql_error());

mysql_select_db("xxx",$conn) or die(mysql_error());

$sql = "SELECT * from table_name";
$result = mysql_query($sql, $conn) or die(mysql_error());

while ($newArray = mysql_fetch_array($result))
{
$id = $newArray['id'];
$name = $newArray['name'];
$thumb_img = $newArray['image'];

echo "<tr><td>$name<button name=\"Choose\" type=\"button\" value=\"$id - $name\">Select</button><br><image src=\"http://www.way/to/image/path/$image\" width=\"100px\" height=\"100px\"></td><tr>";
}
?>

</table>
[/CODE]

Thanks for your help in advanced.

rachel2004

Close off your <tr> at the end of your echo statement:

</tr>

devinemke

how bout something like this:

while ($row = mysql_fetch_assoc($result)) {$array[] = $row;}
$half = ceil(count($array) / 2);
$array = array_chunk($array, $half);

echo '
<table border=1 cellspacing=0 cellpadding=0>
<tr valign="top">
<td width="50%">
';

foreach ($array[0] as $key => $value)
{
	extract($value);
	echo $name . '<button name="Choose" type="button" value="' . $id . ' - ' . $name . '">Select</button><br>
	<image src="http://www.way/to/image/path/' . $image . '" width="100px" height="100px"><br><br>' . "\n";	
}

echo '
</td>
<td width="50%">
';

foreach ($array[1] as $key => $value)
{
	extract($value);
	echo $name . '<button name="Choose" type="button" value="' . $id . ' - ' . $name . '">Select</button><br>
	<image src="http://www.way/to/image/path/' . $image . '" width="100px" height="100px"><br><br>' . "\n";
}

echo '
</td>
</tr>
</table>
';

PoohStix

Cheers Dude(ette)

Works like a charm!