[SOLVED] database row result in other database query

[gli]

Problem starts here WHERE cup=($row['cup'])

 

I try to query where 'cup' equals to some other database row result.

I tried many variations with quotes and other but i can't find sollution, i know i dont know something.

Thanks.

 

Code:

$result2 = mysql_query("SELECT * FROM playerssch
WHERE cup=($row['cup']) and accepted='yes' ") or die(mysql_error()); 
$row2 = mysql_fetch_array($result2);

 

Error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/www/jimperija.atwebpages.com/sch/cup.php on line 11

 

 

 

 

 

[BlueSkyIS]

$result2 = mysql_query("SELECT * FROM playerssch
WHERE cup='{$row['cup']}' and accepted='yes' ") or die(mysql_error());

[gli]

thanks