Help please! (code included) - error on mysql query

[dpenguin]

code:
[code]$db_conn = mysql_connect("localhost", "user", "pw");
mysql_select_db("database", $db_conn);
$query = "select * from table "
."where name='$userid' "
." and pass=password('$password')";
$result = mysql_query($query, $db_conn) or die('Sorry, the query is not able to return a result.');[/code]


This keeps dying. Help?

[Corona4456]

Do:
[code]
$result = mysql_query($query, $db_conn) or die(mysql_error());
[/code]

and post the error message here

[dpenguin]

Ooooooh, thank you!! I had the table columns named incorrectly.  ::) Figures it was something simple.

[Corona4456]

Heh... good deal :).