Quote:
Originally Posted by JamesC
Why exactly do you want to do this?
|
Let's say a house system in which the IDs are IMPORTANTLY stored by sequence. And let's say that any missing ID would screw the whole system up. So when we create a new house, it finds that "Missing" # and inserts it there. ( This is not my system, just an example )
Quote:
Originally Posted by MP2
But he doesn't know which one - read his post.
Can't the INSERT ID thing be used? Not sure.
|
Nope.
Quote:
Originally Posted by [HiC]TheKiller
pawn Код:
new id, xid[10];
mysql_query("SELECT id FROM table");
mysql_store_result();
while(mysql_retrieve_row())
{
id++;
mysql_fetch_field_row(xid, "id"); //Not sure about mysql_fetch_int (May be able to use it in this case)
if(strval(xid) != id) return id;
}
mysql_free_result();
/*
The code above will return the ID that
is missing from the sequence. This is
not really a good idea though, and
there is not many reasons for
doing something like this.
|
Edit: This worked perfectly. Thanks so much!!
