Skipjackrick Posted February 8, 2009 Share Posted February 8, 2009 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()); Quote Link to comment Share on other sites More sharing options...
printf Posted February 8, 2009 Share Posted February 8, 2009 " . $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"; Quote Link to comment Share on other sites More sharing options...
Skipjackrick Posted February 9, 2009 Author Share Posted February 9, 2009 " . $dot . " them or enclose then in curly {brackets}! LIFE SAVER!!! Thanks!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.