hello guys,

i've always made my own php code, but now i got into a little problem, one of my customers wants to generate inceremental id's for it's customers that wii look like the folowing:

1-1-1     1-1-2 1-1-3     1-2-1     1-2-2     1-2-3     1-3-1     1-3-2     1-3-3

2-1-1     2-1-2     2-1-3     2-2-1     2-2-2     2-2-3     2-3-1     2-3-2     2-3-3

3-1-1     3-1-2     3-1-3     3-2-1     3-2-2     3-2-3     3-3-1     3-3-2     3-3-3   and so on...

each group of numbers (eg.1-1-1) representing a different id. for a customer. i've been playing along woth for, if, and while... but i just cann't seem to make this work... can anyone please give me some hints...


I want to make a php script to generate such codes....

   Mike

hum....
your db table should have 2 id´s, one normal id with autoincrement and another field (varchar) to store the "special" id.

ok, now connect to the db, run a query like "SELECT special_id FROM your_table ORDER BY id DESC LIMIT 1;"
ok.

$special_id = (the result of the query, e.g: "1-3-2");
list($one,$two,$three) = explode("-",$special_id);
if ($three != 3){
$three++;
}
else
{
$three = 1;
if ($two != 3){
$two++;
}
else
{
$two = 1;
$one++;
}
}
$new_special_id = "$one-$two-$three";

i didn´t test it, but i think it should work.

I see it as how you store it doesn't have to be completely identical to how you show it.

If you are using a database, why don't you just have 3 auto-incrementing fields for each entry.
Pull each out and display as ' . $row[0] . '-' . $row[1] . '-' . $row[2] . '
If you need to, add another column to identify this combination and use this column's value for associations between other tables.
If you are sure the integrity of the data from the three integers is secure, it doesn't matter if you do not store them in the 1-1-1 way, just display them that way.