[simone]

ok im creating a guestbook and i want to print the array of messeges on my php page. This is the code im using to do so, i get no errors however it's not pulling any of the data from that table in my database. I do have an entry in the DB, so im not trying to retrieve nothing

Code:

<?

include("config.php");


$query = "SELECT id, subject, name, email, site, aim, yim, msn, msg, date, ip FROM eight order by id DESC LIMIT 15";
$result = mysql_query($query);

echo "<br><table align='center' width='75%' cellpadding='4' cellspacing='1' bgcolor='#000000'>";

while($r=mysql_fetch_array($result));
{

echo "<tr>";
echo "<td bgcolor='#FFFFFF'>$r[msg]</td>";
echo "</tr>";
echo "<tr>";
echo "<td bgcolor='#FFFFFF'>Posted By: <a href='mailto:$r[email]'>$r[name]</a> $r[date]</td>";
echo "</tr>"; 
}
echo "</table>"; 

?>

I havent finished entering everything i want to pull yet, thats why theres a tonne of selects and hardly any show results. so any help guys?

[simone]

never mind guys, i worked out i dont need the ; at the end of the fetch array