[RESOLVED] Highest ID

[neroag]

Hi all
Im trying to find the highest id in my database.

ive tried

$query="SELECT * FROM details ORDER BY id ";

but that returns the total number but im trying to get the highest number entry in the id field, as the highest id number chages as people leave or join

can anyone point me in the right direction plz

Thank you

[Houdini]

$query = "SELECT MAX(id) FROM details";

[neroag]

Hi Thank you for the repy

using the following ..
i just get the result of 1 but the highest id in the db so far is 230

 mysql_connect($dhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT MAX(id) FROM details";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo $num;

[Houdini]

The $num that you are echoing will of course return 1 this is how many rows were in the result not the actual information that is contained as a $result of the query. Try echoing the $result.

[neroag]

Sorry all i get is "Resource id #8"

 mysql_connect($dhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT MAX(id) FROM details";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo $result;

:queasy:

doooooh LOL i was closing the link before the result thanx for your help :o