Php script will not work

[Anon]

Hey

I've just started to write php scripts, and i wouldn't know what's wrong with the next one.
<?
$host = "localhost"
$user = "lyrics"
$password = "*****"
mysql_connect($host,$user,$password);
$letter = "".substr($HTTP_GET_VARS["letter"], 0, 2000)."";
@mysql_select_db("lyrics") or die( "Unable to select database");
$query = "select from artiesten where letter = '$letter'";
$result=mysql_query($query);
mysql_close();
/Display Results/
$num=mysql_numrows($result);
$i=0;
while ($i < $num)
{
$id=mysql_result($result,$i,"id");
$artiest=mysql_result($result,$i,"artiest");
$hitcount=mysql_result($result,$i,"hitcount");
$letter=mysql_result($result,$i,"letter");

print ($i % 2) ? "<tr bgcolor=\"000000\">" : "<tr bgcolor=\"000000\">";

print "<td align=middle><a href='liedjes.php?id=$id'><b>$artiest</b></a></td></tr>";
++$i;

}

?>

The following error is given:

Parse error: parse error in /www/htdocs/lyrics/lyrics4you.org/artiesten.php on line 12

Can someone help me??

Thanxx in advance

Greetings Adam

[Anon]

In your mySQL query, throw in a

$result = mysql_query($query) or die(mysql_error());

Does it throw any errors at ya?

[Anon]

No, that doesn't help, still the same error

[junebug]

when defining the 'user' and 'host' and 'password' variables you need to add a semi-colon to the end of the line.

on line twelve you miss spelled the function. should be this:

mysql_num_rows();

fix those. are you still getting an error message?