[PHP-DB] Not seeing whats wrong with code

[Mike Delorme]

Hello,

I am trying to write a script that conects to mysql, then SHA database. Then I need to 
list ALL the rows of table members. It sais there is a error on line 18. The while 
statement is on line 18, and I cant firgure out whats wrong with it:

Advertising

<?
$host = "localhost";
$uname = "sniper";
$pass = "starcraft";
$database = "SHA";
$tablename = "members";
$connect = "mysql_connect ($host, $uname, $pass)"; 
$select = "mysql_select_db ($database)";
$query = "SELECT * from $tablename";
$result = mysql_query ($query)
while ($row = mysql_fetch_row($result))
{
$row
}
?>

Thanks,
Mike Delorme