PHP / MYSQL - determining the highest int value??

TalonFinsky

Hello all,

I am relatively new to the php / sql scene. Just starting my first "real" project after getting a grasp on the basics of both, but I have come across a stumper that sounds to me like it should be easy for you pros 😉

Is there a built in function, in either PHP or MYSQL, that will return the value of the highest number for an auto_incremented integer?

I've done a bit of digging, and so far haven't found one. I was considering putting the contents of the column into a numerically indexed array, using rsort() and pointing to $array[0]. That would work, but seems like a lot to go through, especially if there IS a function to do it for me! 🙂

If anyone knows, post it on up!

Thanks,
~BR

grady

how about use max in your sql statement....
for example....
select max(id) as id from table

TalonFinsky

Thanks for the help.

In the meantime, I remembered the ORDER by argument. That seems to be working now:

  $query = "select * from events order by eventid desc";
  $result = mysql_query($query);

  $newestid = mysql_fetch_array($result);
  echo "<a href=\"viewevent.php?eventid=".$newestid[0]."\">Click here for the latest event.</a><br>"

That seems to work fine. The max call seems to return:

"Resource id #414"

While the above code returns only the id #, which was what I was going for. Thanks for the help though, max will come in handy on this project too 🙂