How to get the largest number from a MySQL database?

[Lauj]

I have a table that have multiple columns. One of those columns is the Section ID column. In this column, the section ID start from 1, 2, 3, 4, 5 and so on. Can anyone show me a query that will give me the highst section ID from this column? For example, the Section IDs that I have are 1, 2, 3, 4, 5, 6, 7. What is the select query that will give me 7?

ljCharlie

[devinemke]

SELECT MAX(Section_ID) FROM table

[Lauj]

Many thanks for the help. But it is still not working. Here's what I tried:

$query_SelectMax = "SELECT max(sectionID) FROM photoGallery";
			$rsMAXID = mysql_query($query_SelectMax, $alumniConnection) or die(mysql_error());
			$totalRows_rsMAXid = mysql_num_rows($rsMAXID);
			if($totalRows_rsMAXid > 0){
				//while($row_rsMAXid = mysql_fetch_assoc($rsMAXID)){
					$row_rsMAXid = mysql_fetch_assoc($rsMAXID);
					$sectionID = $row_rsMAXid["sectionID"];
					$sectionID +=1;
					echo "Section ID: ".$sectionID."<br>";
					//}
				}

It's not giving me the largest number. The query gave me nothing. However, when I run the query in phpMyAdmin, it does give me the correct value. What's going on with my code?

ljCharlie

[devinemke]

$result = mysql_query('SELECT MAX(sectionID) AS max FROM photoGallery') or die(mysql_error());
extract(mysql_fetch_assoc($result));
echo 'Section ID: ' . $max;