I need to use 4 SQL SELECT statements on one PHP Page. I've been trying this:
Code:<?php if (isset($HTTP_GET_VARS["benchmark"])){ $benchmark = $HTTP_GET_VARS["benchmark"]; } // end if if ($benchmark == "3dmark01") { $benchname= "2001"; } if ($benchmark == "3dmark03") { $benchname= "2003"; } if ($benchmark == "3dmark05") { $benchname= "2005"; } $dbServer = "localhost"; $dbDatabase = "xxxx"; $dbUser = "xxxx"; $dbPass = "xxxx"; $sConn = @mysql_connect($dbServer, $dbUser, $dbPass) or die("Couldn't connect to database server"); $dConn = @mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase"); $query = "SELECT MIN(score), MAX(score), AVG(score) FROM $benchmark"; $result = mysql_query($query) or die("Error: " . mysql_error()); $query2 = "SELECT cpu, MIN(score), MAX(score), AVG(score) FROM $benchmark WHERE cpu="intel" GROUP BY cpu"; $result2 = mysql_query($query2) or die("Error: " . mysql_error()); $query3 = "SELECT cpu, MIN(score), MAX(score), AVG(score) FROM $benchmark WHERE cpu="amd" GROUP BY cpu"; $result3 = mysql_query($query3) or die("Error: " . mysql_error()); $query4 = "SELECT video, MIN(score), MAX(score), AVG(score) FROM $benchmark GROUP BY video"; $result4 = mysql_query($query4) or die("Error: " . mysql_error());
I am using these on different parts of the page. The page is basically a large averages page.
I currently get the following error when I add more than 1 of these SELECT statements:
Parse error: parse error, unexpected T_STRING
This error always is on the line where $query2 starts.
It works fine with only the first statement but when I add the second I get the error.
Anyone have a solution for me?
Thanx in advance.![]()




Reply With Quote