Running number counter

neodize

Hi guys,

im doing something like this though unsuccessful

http://board.phpbuilder.com/showthread.php?10338720-RESOLVED-running-number-ih-php

Here's my code

$q4 = "SELECT * FROM tripveh ORDER BY id DESC LIMIT 1";
$r4 = mysql_query($q4) or die ("Error reading from database #2");
while($rw = mysql_fetch_array($r4)) {

$f = $rw['route'];
$g = $rw['id'];
if ($f == "L") {
	$cur = "LL";
} else if ($f == "K") {
	$cur = "KK";
}
$h=0;
$t=$h+1;

$t_id = sprintf("$cur%s-%03d", $g, $t);  

}

if i insert to mysql for the 1st time it would work, the second time & so forth ill get Duplicate entry 'LL20001-001' for key 'PRIMARY'

Can anyone point me to the right direction?

Thanks

dalecosp

Maybe. You don't show an insert query in the excerpt above, but error message regarding "Duplicate entry" is the result of an SQL insert statement.

Your database has a PRIMARY KEY set on whatever field you're trying to put the string "LL2001-001" into. This is to make sure that the column (which is probably named something like ID, or "ordinal", or something) contains only unique values.

It kind of looks like the next ID should be "LL2001-002" ... so if you can construct that number, and use it for the next iteration of the loop?

neodize

It can only go to LL2001-002 and after that it wont add up to LL2001-003 it will say LL2001-002 is duplicated. I cant seem to make $t add up.. or do I need to query back to mysql to check last id?

Weedpacket

You have:

$h=0;
$t=$h+1;

So [font=monospace]$t[/font] will be....?