Insert into database between a set number?

[7724]

Hello,

I have a very quick question. Say I have a database like so:

id | name
1 | John
2 | Mark
3 | Joe
4 | Matt
5 | Ruth
101 | Matt
102| Jeff
103| Mark
104| Lydia
105| Jeff
201| Pike
202 | Niall
204| Webb
205 | Truth

When it comes to inseting a record into the database:

      $result = mysql_query("Insert into tbl (name)  
                   values ('$name')") or die(mysql_error()); 

How can I force my query to insert a row in the database at the next free number between 106 and 200 for instance as normally it would just check the new record on mysql after 205 as 206?

Thanks

[imaginethis]

Hello,

I have a very quick question. Say I have a database like so:

id | name
1 | John
2 | Mark
3 | Joe
4 | Matt
5 | Ruth
101 | Matt
102| Jeff
103| Mark
104| Lydia
105| Jeff
201| Pike
202 | Niall
204| Webb
205 | Truth

When it comes to inseting a record into the database:

      $result = mysql_query("Insert into tbl (name)  
                   values ('$name')") or die(mysql_error()); 

How can I force my query to insert a row in the database at the next free number between 106 and 200 for instance as normally it would just check the new record on mysql after 205 as 206?

Thanks

If you want to manage the identifier yourself, you can disable auto_increment.

[Shrapnel_N5]

7724, there are 2 cases.
1. you don't need id field as unique identifier. so, get rid of it and call it something different. say, "number"
2. you need unique identifier. then don't touch it ever.

[7724]

Thanks Guys,

Have a bit of a problem with this not being my database so id is set as a primary key and auto increments.

This would then cause a problem I guess. Is there any other way around it?

[hash]

You can alter the table to change the next auto increment, or perform selects to find avail numbers in a sequence. But as mentioned, don't touch it, it is irrelevant aside from being a unique identifier.

[Shrapnel_N5]

7724 just tell us reason, why do you want such unusual thing
and real table structure please