mysql help needed

[marcus]

i am making a shoutbox, and when i want to echo/print off the rows in the table it keeps printing thousands of commas

code:

[code]
<?php
include('mysql.php');
$sql = "SELECT * FROM shoutbox";
$res1 = mysql_query($sql);
echo "<tr><td>";
echo "<div style='border:0px solid black; height:200px; width:130px; overflow:auto; font-family:verdana;font-size:10pt;color:black;'>";
while("$res2 = mysql_fetch_assoc($res1), MYSQL BOTH"){
printf ("<a href='$res2[website]'>$res2[name]</a><br>$res2[message]");
};
mysql_free_result($res1);
?>
[/code]

help?

[jcbarr]

Try this;

[code]
while($res2 = mysql_fetch_assoc($res1)){
echo "<a href='$res2['website']'>$res2['name']</a><br>$res2['message']";
};
[/code]

[marcus]

Yep, works perfectly now, thanks!