<?php
function autogen()
{
$qr="Select * from autogen where gid = 1";
$we=mysql_query($qr)or die(mysql_error());
while($brec=mysql_fetch_array($we))
{
$ln=$brec['autoln'];
}
$lw= ++$ln;
return $lw;
}
$newlead=autogen();
$qry="Select * from leads";
$r=mysql_query($qry) or die(mysql_error());
while($re=mysql_fetch_array($r))
{
if($rec['leadno']==$newlead)
{
++$newlead;
}
}
$er="UPDATE autogen SET autoln='$newlead'WHERE gid =1";
$bn=mysql_query($er)or die(mysql_error());
?>
This Code generates the key like LEA4545
but this code have some flaws same id could be inserted in table
although i have set in fuction in same found incre ent in it..
and the second flaw is this if i delete the keys ..then the new one created key must be from deleted keys