[SOLVED] How do I pull out the highest value in MySQL?

[Klance]

I want to display the highest score of a song from the db GHScores the table GH80 and the field Score. The field Score holds all the scores, how do I just pull out just the highest score?

[discomatt]

ORDER BY `score` DESC LIMIT 1

[effigy]

SELECT MAX(field) FROM table

[unidox]

SELECT MAX(field) FROM table

 

That will work.

[Klance]

Ok, I tried that and it came out with

 

"Resource id #2"

 

Heres the code I used:

 

<?php

$host = "localhost";
$user = "root";
$pass = "****";
$db = "GHScores";

$conn = mysql_connect($host, $user, $pass) or die("Unable to connect!") ;

mysql_select_db($db) or die("Unable to select database!");

$query = "SELECT MAX(score) FROM GH80";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

echo $result
?>

[discomatt]

<?php

$host = "localhost";
$user = "root";
$pass = "****";
$db = "GHScores";

$conn = mysql_connect($host, $user, $pass) or die("Unable to connect!") ;

mysql_select_db($db) or die("Unable to select database!");

$query = "SELECT MAX(score) FROM GH80";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

echo mysql_result($result, 0);
?>

[Klance]

<?php

$host = "localhost";
$user = "root";
$pass = "****";
$db = "GHScores";

$conn = mysql_connect($host, $user, $pass) or die("Unable to connect!") ;

mysql_select_db($db) or die("Unable to select database!");

$query = "SELECT MAX(score) FROM GH80";

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

echo mysql_result($result, 0);
?>

 

Thank you