id realetd problms ???

[12345xmen]

hi dear in my site i clear my sql data but when any user register there his member id start with 80 nd onward bcoz before in data 80 meber register so what id do its start with 1 plz tel meeeeeeeeeee

[WhiteWarrior]

Flush the table should do the trick.

[12345xmen]

how i flush the table

[12345xmen]

1 more error i get when sending pm to ny user

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/mysite.info/121inbxproc121.php on line 153

my inbxproc.php code at 153 line is

while ($item = mysql_fetch_array($items))


$items = mysql_query($sql);


echo mysql_error();
while ($item = mysql_fetch_array($items))
{
if($item[3]=="1")
{
$iml = "<img src=\"images/npm.gif\" alt=\"+\"/>";
}else{
if($item[4]=="1")

tel me where is fault

[ripkk2tfk]

while ($item = mysql_fetch_array($items))
$items = mysql_query($sql);

If im not mistaken it should be:

[B]while ($item = mysql_fetch_array($items))[/B]
{
$items = mysql_query($sql);
}

[kazzin]

go to ibwf_users then click on operation flush the table

[12345xmen]

Okz thanks bro i try.

[metulj]

Flush the table should do the trick.

i though 'TRUNCATE' would do the job

[WhiteWarrior]

yeah that would also work but id rather use flush, dont ask why lol

[12345xmen]

i get error when i flush ibf user

#1227 - Access denied; you need the RELOAD privilege for this operation


wht i do in free hostia no user privalage so how i flush ???????

[morse]

yeah that would also work but id rather use flush, dont ask why lol

WHY ?

[Vayne]

just paste this in query log---

TRUNCATE `ibwf_users` 

[12345xmen]

Yh truncate function wrk i dnt use flush in free hostia .its nt wrk in free hostia . .bt via truncate my problem solve thanks