Max Min Query Help

tazdog

Being pretty new to mysql, I want to see how this query can be accomplished..

What I want to do is take say one field with 50 records in it..
I want to select the max # (say 150) and then take the min # (say 75)

And when you run a query I want it to take both these figures and then display the difference (75)

Is this possible and if so, is there some documentation on the net that would discuss a query of this type, putting it all together..

thanks
Scott

rincewind456

Group By Functions in MySQL.

devinemke

$result = mysql_query('SELECT MIN(id) AS min, MAX(id) AS max FROM table') or exit(mysql_error());
$row = mysql_fetch_assoc($result);
$diff = $row['max'] - $row['min'];

tazdog

devinemke wrote:

$result = mysql_query('SELECT MIN(contact_id) AS min, MAX(contact_id) AS max FROM table') or exit(mysql_error());
$row = mysql_fetch_assoc($result);
$diff = $row['max'] - $row['min'];

Ok I put this in and now trying to get the results posted..

Here is the code i'm using for that (which works on other query's)

echo "<table align=center width=600px border=\"1\">\n";
						echo "<tr bgcolor=\"lightblue\"><td><b>Name</b></td><td><b>Weight</b></td><td><b>BP</b></td><td><b>Date\Time</b></td></tr>\n";
						for ($i = 0; $i < $numrows; $i++)
						{
						$row = mysql_fetch_array($result);

					if ($i % 2) {
						echo "<tr bgcolor=\"#fffee2\">\n";
						} else {
							echo "<tr bgcolor=\"#f7f7f7\">\n";
						}
						echo "<td>".$row['Name']."<td>".$row['Weight']."<td>".$row['BP']."<td>".$row['DateEntered']."</td>\n";
							echo "</tr>\n";
						}
						echo "</table>\n";

Somewhere I know i need to add in $diff but not sure where.
I did replace the $numrows with $diff and that didnt work..

thanks
Scott