Increment

[Anon]

Is there way to make your own Increment for MySQL besides using auto_increment in MYSQL?

[toma42]

The database class for mysql in pear has a nextID() function that uses a small table like a sequence.

[Anon]

<?php
// Connect to the database.
$query = "select max(id) from testTable limit 0, 100";
$result = mysql_query($query) or die("Error when incrementing.");
while(list($id) = mysql_fetch_row($result))
{
print("Current id is: $id");
$id++;
print("The next id is: $id");
}
// Close the database connection.
?>

I use this all the time. I haven't gotten around to trying a better "condition" statement. I think if "limit 0, 100" were to be replaced by "where sign(id) = 1", it would work equally if not better than limiting the amount of rows in your database to 100. I haven't tried that out yet though.

Just reply back here if there are any problems.

[Anon]

<?php
// Connect to the database.
$query = "select id + 1 from testTable limit 0, 100";
$result = mysql_query($query) or die("Error when incrementing.");
while(list($id) = mysql_fetch_row($result))
{
print("The next id is: $id");
}
// Close the database connection.
?>

The only change I made here was the piece from "max(id)" to "id + 1". This will make the value of the variable $id already incremented ahead of time. Almost the same thing as the one before only slightly less coding and the incrementing has already been handled. Again, I haven't tried this one out. But off the top of my head and some resources I'm pretty sure this should work equally well to conform to your specifications.