Array Dispaly problem

[phpdeano]

I have the following that displays the contents of a table field.....
However I need the results in 3 columns rater than the 1 column.

Any help graetly appreciated.

Current script

<?php
//Get Models
$sql = "Select distinct longdescription from cdeval where manufacturer = '$manufacturer' order by longdescription";
// run SQL against the DB
$result = mysql_query($sql)
or die("Get models failed");
?>
<center>
<table border=1 bgcolor="#CCCCCC"><tr><td>
<table width=100% bgcolor="#CCCCCC">
<tr>
<td align=center><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Deal</td>
</tr>
<tr>
<?php

while ($myrow = mysql_fetch_array($result)) 

{
printf(
"<td width='600'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"2\"><a href=\"value2.php?manufacturer=$manufacturer&longdescription=%s&username=$username&password=$password\">%s</a></td>
</tr>",
$myrow["longdescription"],$myrow["longdescription"]
);
}

?>

</table>

Thanks
Deano

[sarahk]

Have you tried
$td = "<td width='600'>";
$cnter = 1;
echo "<table>";
while ($myrow = mysql_fetch_array($result))
{
if ($cnter == 1) echo "<tr>";
echo $td . "<a href=\"value2.php?manufacturer=$manufacturer&longdescription=%s&username=$username&password=$password\">%s</a></td> ";
if ($cnter == 3) {
echo "</tr>";
$cnter = 1;
}
else $cnter++;
}
echo "</table>";

[Anon]

Hi Sarah,

I know this is a stupid question, but...

I can not work out where I need to add the $myrow["manufacturer"] to define what the %s value is.

Please help

Regards
Deano

[phpdeano]

Please ignore the previous message, all is resolved.

Thank you for the help to resolve my problem.