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

[Barand]

SELECT MAX(site_id) FROM tablename

[woocha]

SELECT MAX(site_id) FROM tablename

Is that is the SQL query I should execute?

[Barand]

yes

<?php
$res = mysql_query("SELECT MAX(site_id) FROM tablename");
$highest_site_id = mysql_result($res,0);

[woocha]

Thanks Barand....You're awesome