I am trying to get a single result from a database, which works fine at the sql command line. I have tried several versions of code, this being the most recent - <? $sql = "select max(WarrantyID) from warrantycopy"; $result=mysql_query($sql) or die("Could not get the id number :" . mysql_error()); while($query_data = mysql_fetch_array($result)) { $WarrantyID = $query_data["WarrantyID"]; echo "<tr>\n"; echo "<th>Warranty ID:</th>\n"; echo "<td>$WarrantyID</td>\n"; echo "</tr>\n"; } ?> No matter what I do I do not get the desired max id number from the column WarrantyID. The same query works fine at the sql command line. What am I doing wrong? thanks