My first query isn't working

[Anon]

I've search the postings for quite a while, but since my searches turned up thousands of results even when I made them more specific, I've given up.

For my first DB query, I've tried to replicate a simple script from a book. Just to get a feel for it. The example shoved the results into a table, but I don't even want to do that - just make sure I can pull data before I worry about formatting it.

But I get a parse error on line 17 each time.

Is there something I'm missing? I've stared at it for hours!
<?php
$Host="localhost";
$User = "myUserName";
$Password= "myPassword";
$DBName="myDBName";
$TableName= "events"

$link = mysql_connect ($Host, $User, $Password);
$Query = "SELECT * from $TableName";
$Result = "mysql_db_query ($DBName, $Query, $Link);

while ($Row = mysql_fetch_array($Result))
{
print ("<p>\n");
print ("$Row[eventName]\n");
print ("<BR>\n">;
}
mysql_close($Link);

?>

THANKS if anyone can help!

[Anon]

You are missing a ; on this line:

$TableName= "events"

If that was just a copying error you also have " where you shouldn't on this line:

$Result = "mysql_db_query ($DBName, $Query, $Link);

[danielle]

Don't give up Larisa - there isn't a PHP programmer in the world who hasn't (a still does sometimes) done that.

[Anon]

Thank you both so much for both the help and encouragement. I've always used Cold Fusion to do database integration before. It's discouraging to start over with a new package - but PHP is certainly easier on the pocketbook.

My query now works, and I'm off to format it nicely.

Thanks!