Select highest value from column in database table

[ecopetition]

Hey,

 

In a MySQL database, how, if it is possible, can I have a script return the highest value in a particular column of a table?

 

Thank you.

Peter

[MasterACE14]

SELECT MAX(column) FROM table WHERE whatever='whatever'

 

I think its max. I'm not 100% sure.

[ecopetition]

Thanks but then from the code:

 

{
	$sql = "SELECT MAX(post_id)
	  	  FROM posts"
	          ;
		  $result = $db->query($sql);
		  while($row = $db->fetch_assoc($result))
		  {
		  	$highest_post[] = $row;
		  }
  }

 

"$highest_post" is an array rather than a number. Any ideas what's wrong?

 

Thanks.

[Gibbs]

Thanks but then from the code:

 

{
	$sql = "SELECT MAX(post_id)
	  	  FROM posts"
	          ;
		  $result = $db->query($sql);
		  while($row = $db->fetch_assoc($result))
		  {
		  	$highest_post[] = $row;
		  }
  }

 

"$highest_post" is an array rather than a number. Any ideas what's wrong?

 

Thanks.

 

Remove the [] in $highest_post, 8th line.

[ecopetition]

It's still returning an array.

[obsidian]

Remember that mysql_fetch_* always returns an array of results. You need to target the specific result you are after:

 

<?php
$sql = mysql_query("SELECT MAX(col) AS max FROM my_table");

// Either get it directly like this:
$val = mysql_result($sql, 0, 'max');

// Or, fetch and get the array val:
$res = mysql_fetch_assoc($sql);
$val = $res['max'];
?>

 

Good luck.