[RESOLVED] Select Max Query

[Amplifier]

Hi, I'm trying to figure out how to display a max value once it's been selected from the database. Here's a snippet of code that should give you an idea what I'm trying to do..

	$SQLQuery1 = "select max(customerID) from customer";
	$ResultSet2 = mysqli_query($DBConnect, $SQLQuery1);
		if (!$ResultSet2)
			die("<p>Unable to execute the query.</p>");
	$Row1 = mysqli_fetch_assoc($ResultSet2);
	echo $Row1['customerID'];

Thanks in advance for your help 🙂

[paulnaj]

Two ways ...

1.

$SQLQuery1 = "select max(customerID) from customer";
$ResultSet2 = mysqli_query($DBConnect, $SQLQuery1);
if (!$ResultSet2)
    die("<p>Unable to execute the query.</p>");
$Row1 = mysqli_fetch_row($ResultSet2);
echo $Row1[0]; 

2.

$SQLQuery1 = "select max(customerID) as `max_customer_id` from customer";
$ResultSet2 = mysqli_query($DBConnect, $SQLQuery1);
if (!$ResultSet2)
     die("<p>Unable to execute the query.</p>");
$Row1 = mysqli_fetch_assoc($ResultSet2);
echo $Row1['max_customer_id']; 

P.

[Amplifier]

Thank you so much! Lots of website said how to write the query but not how to turn it into a usable value in php. Once again this forum has saved me, you guys are great 😃