[CarBoffin]

Hello,
I would like to get the highest number from a mysql table field called ID, add 1 to it and store the result number as a variable called $id.

Thanks

[digioz]

Wouldn't it be easier if you Auto-incremented the ID instead of reading the last ID and adding one to it?

Originally Posted by CarBoffin

Hello,
I would like to get the highest number from a mysql table field called ID, add 1 to it and store the result number as a variable called $id.

Thanks

[CarBoffin]

yes, i need to re-think what i'm doing...

[nucking_futs]

Ok I do need to actually do this. I need to be able to add a number to only certain posts that a bulletin board makes. I have the part taken care of that defines which posts are which, but I really do need to do what was asked about originally.

I read something on max and array, but am not grasping it.

I am using PHP and MySQL.

Thanks!!

[digioz]

You can use the "max" functions:

Code:

<?php
echo max(1, 3, 5, 6, 7); // 7
echo max(array(2, 4, 5)); // 5
?>

All you have to do is to read the values from your MySQL table column into an array, and feed that array to the "max" functions to find the highest value.

Originally Posted by nucking_futs

Ok I do need to actually do this. I need to be able to add a number to only certain posts that a bulletin board makes. I have the part taken care of that defines which posts are which, but I really do need to do what was asked about originally.

I read something on max and array, but am not grasping it.

I am using PHP and MySQL.

Thanks!!

[Apoc]

could you not just use the MAX function within SQL, ie:

select max(id) from table where constaints;

that would then return the highest number in that column?

HTH

<?Apoc?>