Showing records in a table with 2 cols

smiter

Hello,

I am busy with the site of the company I work for. We have a section where al our partners are mentioned. At this moment this is a static part of the website that I want to make dynamically.

This is the url of the static page and how it should look like:

http://www.telecom.nl/english/partners.htm

This is the url of the dynamic page I created but it doesn't work the way that I want:

http://www.telecom.nl/english/partners_db.php

This is the php code I used:

<?php 

$i=0; 
echo "<tr>";         

while (list($id, $vlag, $land, $bedrijf, $website, $email) = mysql_fetch_row($result)){ 

echo "<td><table>-Content with the data of the records-</table></td>"; 

if($i % 2 == 0) { 
echo "</tr><tr>"; 
} 
$i++; 
} 
echo "</tr>"; 
// close connection
mysql_close($db); 
?>

Maybe someone can take a look at my code and help me further on doing this.

Thank in advance.

Smiter

Nomaad

Here is one I used . . .

$count = 1;

$column = 1;

$query = "SELECT id, company_name, web_link, name, path FROM wholesaler_links ORDER BY 'company_name' ASC";
$result = mysql_query($query) or die('Error, query failed: ' . mysql_error());

while(list($id, $coName, $link, $name, $path) = mysql_fetch_array($result))

{

if ($column == 1)

{

echo "<tr><td align=\"center\" valign=\"middle\"><b><a href=\"$link\" target=\"_blank\"><img src=\"$path\" alt=\"$coName\" border=\"0\"></a></b></td>";

}

else{

echo "<td align=\"center\" valign=\"middle\"><b><a href=\"$link\" target=\"_blank\"><img src=\"$path\" alt=\"$coName\" border=\"0\"></a></b></td></tr>";

}

$count += 1;

$column = $count % 2;

}

Hope this helps.