Query Question... MAX

[Pilly]

Can someone explain whats wrong with this?

//////////// Query To Highest Score ////////////////////
$query4="Select MAX(HighestScore) AS MAX_HISCORE FROM Darts_SGS WHERE Darts_SGS.Player='$name'";
mysql_query($query4);
//execute SQL query and get result
$sql_result4 = mysql_query($query4,$connection)
or die("Couldn't execute query4.");

///////////////////////////////////////////////////////////////

Ive tried variations on this, mostly it Couldnt execute, sometimes Resource id #11 ??? Any ideas guys??

[stolzyboy]

what are you doing to gather the results array after you have it stored in $sql_result4

[Pilly]

Goes onto a html page. the row is

<td height='30' width='336' bgcolor='#EFF3F7' bordercolor='#FFFFFF'>
<font face='Verdana' size='1'>$sql_result4 - $MAX_HISCORE</font></td>

[stolzyboy]

you need to fetch the results somehow, you can't just echo it out

<?
while ($row = mysql_fetch_array($sql_result4))
{
echo $row['MAX_HISCORE']; // you can do whatever html here
//and you can hop in and out of php like you did before too
}
?>

[Pilly]

Ive used

$query4="Select MAX(HighestScore) AS MAX_HISCORE FROM Darts_SGS";
mysql_query($query4);
//execute SQL query and get result
$sql_result4 = mysql_query($query4,$connection)
or die("Couldn't execute query4.");
$HI = mysql_result($sql_result4, 0)
or die ("The query: '$query' did not return any data");

It seems to have got the answer i was looking for.... is that ok?

[stolzyboy]

ummm....obviously not if it isn't working
try using what i have you and see if it echos anything out

if so then wrap your html around and in the while loop to get the
desired formatting

[Pilly]

it is working..... I think its a go-er now...

a million thanks.

[stolzyboy]

what was the solution

[Pilly]

This solved it.

$query4="Select MAX(HighestScore) AS MAX_HISCORE FROM Darts_SGS";
mysql_query($query4);
//execute SQL query and get result
$sql_result4 = mysql_query($query4,$connection)
or die("Couldn't execute query4.");
$HI = mysql_result($sql_result4, 0)
or die ("The query: '$query' did not return any data");

Then used $HI in the HTML part