[RESOLVED] MySQL While { stuff }

Hi,

Seem to be having a small probelm, if i run the script below, works fine all the users shows up

[code=php]
<?

//DB STUFF

$connection = mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($dbname);

$sql =”SELECT * FROM PHPAUCTION_users”;
$result = mysql_query($sql) or die(mysql_error());
while ($sql = mysql_fetch_object($result))

{

$user = $sql -> nick;
$pass = $sql -> password;
$email = $sql -> email;

echo “$user – $pass – $email<BR>”;

}

?>[/code]

but if i run this one it doesnt do every user, only the first one

[code=php]
<?

//DB STUFF

$connection = mysql_connect($dbhost, $dbuser, $dbpasswd);
mysql_select_db($dbname);

$sql =”SELECT * FROM PHPAUCTION_users”;
$result = mysql_query($sql) or die(mysql_error());
while ($sql = mysql_fetch_object($result))

{

$user = $sql -> nick;
$pass = $sql -> password;
$email = $sql -> email;

$results = “INSERT INTO phpbb_users (user_id, username, user_password, user_email)
VALUES (‘$user_id’, ‘”.$user.”‘, ‘”.$pass.”‘, ‘$email’)”;
$ress=mysql_query ($results) or die(mysql_error());

$sql =”SELECT * FROM phpbb_users”;
$result = mysql_query($sql) or die(mysql_error());
while ($sql = mysql_fetch_object($result))

{

$user_id = $sql -> user_id;

}

$results1 = “INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator)
VALUES (”, ‘Personal User’, 1, 0)”;
$resss=mysql_query ($results1) or die(mysql_error());

$results2 = “INSERT INTO phpbb_user_group (user_id, group_id, user_pending)
VALUES (‘$user_id’, ”, ‘0’)”;
$ressss=mysql_query ($results2) or die(mysql_error());

echo “$user – $pass – $email<BR>”;

}

?>[/code]

Thanks for any help!
Aaron

Also in #PHP _↴