How to select a mysql database in php?

Question

I have a client where their next auto-increment number just jumped from 2300 to ********** for reasons not understood. They want it set back.

Options such as dropping the primary key and rebuilding the index is NOT possible -- this is a relational table thing. So, is there a way (programmatically) to set the next number in an auto-increment?

Something like:

alter table abc auto_increment = 2301;

Any ideas of why this happened?

Answer 1

Using mysql_select_db() function we can select a database in PHP is mysql is in connected state. Following sample code may help you -

$db=mysql_pconnect(<hostname>, <username>, <password>);
if (is_resource($db)) {
   if (!mysql_select_db(<database>, $db)) {
          mysql_close($db);
          // <report error>;
    }
}
// Now we can use $db in various operation