Syntax Problem with Predefined Variables

[Skipjackrick]

I am trying to use a variable from a query result in another query.

 

First I set the variables in an array.

$querymembers = "SELECT 
		angler, team_id
		FROM anglers
		WHERE team_id=1
		GROUP BY angler
		LIMIT 5";
$teamanglers = mysql_query($querymembers) or die(mysql_error());

while($row = mysql_fetch_assoc($teamanglers)) {
   $results[] = $row;
}

 

I know for a fact that this

 $results[0]['angler']; 

will output "1" which is what I want.  However, in the second query I get the following error.

 

Parse error: syntax error, unexpected T_VARIABLE

 

What is my problem?  Besides being lazy....HAHA

 

$query_anglertotals = "SELECT
                         species_id,
                         SUM(IF(angler="$results[0]['angler']",1,0)) AS anglerA,
                         SUM(IF(angler="$results[0]['angler']",1,0)) AS anglerB,
                         SUM(IF(angler="$results[0]['angler']",1,0)) AS anglerC,
                         SUM(IF(angler="$results[0]['angler']",1,0)) AS anglerD,
                         SUM(IF(angler="$results[0]['angler']",1,0)) AS anglerE
                         FROM submit
                         WHERE team_id=1
                         GROUP BY species_id
                         ORDER BY species_id";

$anglertotals = mysql_query($query_anglertotals) or die(mysql_error());

[printf]

" . $dot . " them or enclose then in curly {brackets}!

 

 

$query_anglertotals = "SELECT
                         species_id,
                         SUM(IF(angler="' . $results[0]['angler'] . '",1,0)) AS anglerA,
                         SUM(IF(angler="' . $results[0]['angler'] . '",1,0)) AS anglerB,
                         SUM(IF(angler="' . $results[0]['angler'] . '",1,0)) AS anglerC,
                         SUM(IF(angler="' . $results[0]['angler'] . '",1,0)) AS anglerD,
                         SUM(IF(angler="' . $results[0]['angler'] . '",1,0)) AS anglerE
                         FROM submit
                         WHERE team_id=1
                         GROUP BY species_id
                         ORDER BY species_id";

[Skipjackrick]

" . $dot . " them or enclose then in curly {brackets}!

 

LIFE SAVER!!!

 

Thanks!!