What is the method to find the number of rows in a result set using 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

With the help of function mysql_num_rows() ,you can find out the number of rows in result set.

For Example:
$result= mysql_query($sql,$db_link);
$rowcount=mysql_num_rows($result);
echo "$rowcount";

Answer 2

how to fetch country ,state, and city, please recomdedd me