mySQL Query and order by highest number and grab highest result

[woocha]

Hey Guys,

I have a massive DB and want to search one of the fields titled site_id. I want to search the field for the highest number and then assign that number to a variable. This way I can have PHP add 1 to the variable and then insert it into a new field. The whole point of this is to get around the limit of 1 auto increment per table. Does anyone have any suggestions.

Thanks Guys

[laserlight]

I want to search the field for the highest number and then assign that number to a variable.

That can be done by using the MAX(x) SQL aggregate function for a column named x.

This way I can have PHP add 1 to the variable and then insert it into a new field. The whole point of this is to get around the limit of 1 auto increment per table.

But why do you want to have more than one auto incremented column in the first place?

[woocha]

The software and DB were both built by someone else and the software is huge. I know some scripts use the the auto incr field and the stuff I am working on now uses the field titled site_id.

So you say i should just execute:
SELECT MAX(site_id) FROM tablename
in my PHP code?

[laserlight]

Pretty much, with the usual database related functions involved, of course.

[woocha]

Thanks for the help and the quick reply 🙂