[Resolved] Selecting Highest Integer in Column

[Ghost_81st]

How would I go about this? I want to display the largest value from the column

[LordShryku]

SELECT max(field)
FROM table

[Sxooter]

A better performing query on MVCC databases like postgresql is to use:

select id from table order by id desc limit 1

PostgreSQL can't use indexes on aggregate functions, but can on a limit clause.

[Ghost_81st]

I get "Resource id #5". I know that it is working, but how to make it display the integer

[laserlight]

Which DBMS are you using?

Basically, you need to extract the data from the result set returned (as a resource in PHP).

[Ghost_81st]

MySQL

[tsinka]

Hi,

you need to do something like e.g.

$res = mysql_query("SELECT MAX(field) AS num FROM table");
$row = mysql_fetch_array($res);
$max = $row['num'];

Thomas

[Ghost_81st]

Thank you everyone who helped me out.
It works beautifuly