Insert data needs correct id as it skips id's

[kevin66]

Hi. When I add data to a table from a php form, the new entry is say 7 but the previous one was 2. It skips numbers when adding a new row. Any help please. Can I define the next ID when I submit the data?

 

Thanks

[amolv]

plz check auto increment attr..

[kevin66]

Thanks I have looked at this. I can only see examples where it is used when creating tables but not when inserting a new row. Any ideas on how? I am very new to php/mysql.

 

Here is my code so far -

 

$name = $_POST['name'];

  $email = $_POST['email'];

  $sql = "INSERT INTO properties SET Band_4_Room='$name', Band_4_Price='$email'";

         

  if (@mysql_query($sql)) {

    echo('<p>New employee added</p>');

  } else {

    echo('<p>Error adding new employee: ' . mysql_error() . '</p>');

  }

  // This finds the id of the row once it has been added...

$id = MYSQL_INSERT_ID();

 

// Display it...

ECHO $id;

[fenway]

You shouldn't be wanting to define a unique number -- that's the database's job.

[amolv]

after addition of one row use maxid in select query will gives you id of an currently added record.

[fenway]

after addition of one row use maxid in select query will gives you id of an currently added record.

No, it won't.  That's not thread-safe.

[amolv]

http://php.net/manual/en/function.mysql-insert-id.php

 

mysql_insert_id ([ resource $link_identifier ] )

 

Retrieves the ID generated for an AUTO_INCREMENT column by the previous query (usually INSERT).

 

ie unique id required and it will solve problem.