I'm using the following:
PHP Code:
 $s = mssql_connect($myServer, $myUser, $myPass) 
or die("Couldn't connect to SQL Server on $myServer"); 

$d = mssql_select_db($myDB, $s) 
or die("Couldn't open database $myDB"); 

$query = "SELECT MAX([Revision Date]) "; 
$query .= "FROM [Program Revision Level]"; 

$result = mssql_query($query); 
$row = mssql_fetch_array($result);


echo $row["Revision Date"];


echo "<br>Latest Revision Date: ". $row["Revision Date"];

$query = "SELECT MAX([Revision Level]) "; 
$query .= "FROM [Program Revision Level] "; 

$result = mssql_query($query); 
$row = mssql_fetch_array($result);

echo "<br>Latest Revision Level: ". $row["Revision Level"]; 
Both queries should return only 1 value, but I can't seem to figure out how to get that result. I know I'm connected to the DB, I know the field names and DB name is correct. Can someone tell me how to echo a single result from a query?