[SOLVED] Maybe I'm tired

[Greaser9780]

Anyone know what's wrong with this:

$name_sql = mysql_query("SELECT name FROM `draft_teams` WHERE `name` ='$name'");

$pass_sql = mysql_query("SELECT pass FROM `draft_teams` WHERE `pass` ='$pass'");

 

$name_match=mysql_result($name_sql, 0, 'name_match');

$pass_match= mysql_result($pass_sql, 0, 'pass_match');

 

Here's the error:

Warning: mysql_result() [function.mysql-result]: name_match not found in MySQL result index 3 in select.php on line 31

 

[btherl]

The column is called name, not name_match

[Greaser9780]

You mean in my ($res, 0, 'name')

[Greaser9780]

TYVM