how can I empty my records

[vividona]

Hiiii,

still checking my funny script

Now I have another problem

see here


CREATE TABLE `userregdata` (
`uid` mediumint(5) unsigned NOT NULL auto_increment,
`ufname` varchar(30) NOT NULL,
`ufamname` varchar(30) NOT NULL,
`username` varchar(30) NOT NULL,
`upswd` varchar(15) NOT NULL,
`uemail` varchar(40) NOT NULL,
`unumlev` int(3) NOT NULL default '1',
`uipadd` varchar(16) NOT NULL,
`uregdate` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`uid`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


as row (uid) is an auto-increment, the administrator should have row uid = 1

this is ok my script till now works fine

but the thing which is not fine, if I drop the database and need to install my script again
and when administrator register during installation process sometimes I found my script gave him uid number 3 , 4, 5 or 6 . . . etc instade of 1

how can I direct my script to uid = 1
how can I empty my record before the process of adminstrator registration


if( ! parent::getmail() == 0){
$QUERY = sprintf("INSERT INTO %s (`ufname`, `ufamname`,`username`, `upswd`,
`uemail`, `uipadd`, `uregdate`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', NOW())",
parent::BHL_DB_USER_TBL, parent::ClnUserFname(), parent::ClnUserFamName(), parent::ClnUserName(), parent::ClnUserPswd(),
parent::ClnUserEmAdd(), parent::CheckIpAdd(), parent::CurDate())or die(mysql_error());
$Result = mysql_query($QUERY);
}

[james438]

I cheat. When I use auto increment I would occasionally delete a file and there would be a gap in the ID# sequence or I would delete all of the records and want to start over from ID of one and move up sequentially from there or where ever the deleted file occurred. I created the following a while back

$ID2=0;
$get_list1 = "select ID from table";
$get_list_res1 = mysql_query($get_list1) or die(mysql_error());
while ($recs1 = mysql_fetch_array($get_list_res1)) {
$IDa = $recs1['ID'];
if (($IDa-$ID)>1) {$ID++;$ID2=4;break;}
$ID=$IDa;
} if ($ID2<=1) $ID++;
echo $ID;

It scans the table and determines the appropriate ID# to use next by first looking for gaps in the ID# of the table and then displaying the next ID# if there are no gaps.

[vividona]

hiiiii,

sometimes refuse to give uid = 1 if I drop my databse of no

I discover this now

I installed it new server

I found out uid = 6