PHP - While Loop Problem

A WHILE loop in a FOR loop problem

Script about links and sublinks from 1 table.

In fact 2 questions about that.
1) In the FOR loop I have for example to do the loop 3 times. (needs to find 3 results withing the loop with if and else)
When first time, he's gonna search within the WHILE loop that holds (for example) 10 records of the DB in a variable.
He needs to search for rowid number 5, he found it
He goes out of the WHILE loop and goes searching again but now for rowid number 2
 
Now it seem that the WHILE loop start searching for number 2 but won't start from his first row in the variable (10 rows from the db ).
He start at row number 6 instead of beginning all over again !!!

-> so the order of the numbers of rows MUST be in an ascending order, ortherwise he won't find them all ! But the numbers I have are NOT in an ascending order !!!
Why doesn't the WHILE loop begin again from his row 1 in the variable ?

FOR loop
{
   WHILE loop    {   content here,     break;  }
 }


2) even when I get all the result in an ascending order, he won't go doing a second search but with a different rowid number that he gets from the FOR loop.
It is giving me back indeed the right new rowid number,  but the WHILE loop is doing nothing. 
I have put many echo "..."; and other stuff for checking but can't find the cause !

Here's the code :

Code: [Select]
// $ResultShow = 10 rows from mysql db
if(isset($ResultShow)){

if (mysql_num_rows($ResultShow) >= 1){


//$linksuborder = "2,3,4";
$array1 = explode(",", $linksuborder);
sort($array1);

for ($n = 0;  $n < count($array1);  $n++){ // searchin for the right row id in the variable $ResultShow where we find the numbers for next loop
$r1 = each($array1);

While($Row2 = mysql_fetch_array($ResultShow))  {
 
if($Row2["linkid"] == $r1['value'])  // found it, now look for the numbers that we'll put in an array
{  echo "---here the content---"; 

// linksuborder is where numbers from row id's are stored like  5,2,8
//now put them in an array
$array2 = explode(",", $Row2["linksuborder"]);
        sort($array2);

for ($n2 = 0;  $n2 < count($array2);  $n2++){
$r2 = each($array2);

////// here searching for the sublinks //////
While ($Row3 = mysql_fetch_array($ResultShow))
{
if($Row3["linkid"] == $r2['value']) // search for the right row id within the variable $ResultShow
{
echo "---here the content---";
  break; // found it, so no need to do the rest of the loop
 
} // end if
} //end while
////// end searching for sublinks //////

}  // end for
}  // end if

else
{
echo "--- content here ---"; 
}
 


}  // end while
}  // end for


} //end if
} // end if


Table :

linkid     linksuborder     linktitle
1                  2,3,4   
2                  9,7,8           mainlink1
3                  10               mainlink2
4                                     mainlink3
5
6
7                                      sublink3
8                                      sublink2
9                                      sublink1
10                                    sublink4

-> linksuborder 2,3,4 are the row id's for the mainlink
-> than we put the numbers 9,8,7  (also row id's)  mentioned in row linkid 2  also in a new array
-> now we can search for the sublinks
-> get the details from row linkid 9, than 7, than 8

-> First mainlink is compleet, now go to row linkid 3 to do it all over again for the next mainlink...


RESULTS from an sorted array -> sort($linksuborder);
-------------------------------------------------------------
mainlink1 : sublink1, sublink2, sublink3

mainlink2  : **no result back  but it should *

mainlink 3 : **no result back  but it should *

I hate asking help twice in the same day but im really stuck

Im having problem with this loop im writing.

I'm randomly grabing a name from an array then im checking to make sure it doesnt exist already in the database
if it does then it loops back and grabs another name.  I'm having problems with seeing whats going on while its looping
I inserted a name in the data base to match "AGENA" so if AGENA is the end result i know its not working.  right now its not even looping.

$planet_names = "
AGENA 
Deneb 
Zuben 
Zosma";

$explode_names = explode(" ", $planet_names);

$random_key_name = (array_rand($explode_names, 1));

$planet_name = $explode_names[$random_key_name];


$loop_again = 0;

while ($loop_again > 1) {

                               $name_check3 = "SELECT address FROM planets WHERE name = '".($planet_name)."'";
                               $name_check2 = mysql_query($name_check3) or trigger_error("SQL", E_USER_ERROR);
                               $name_check1 = mysql_num_rows($name_check2);


if($name_check1 >= "1"){ // checks to see if name exists

$loop_again = 1;
}else{
++$loop_again;
$planet_name = $planet_name;

}
}
echo "It ran $loop_again times<br />";
echo "$name_check1 match found equals 1. No match found equals 0<br />";
echo $planet_name . "<br />"; 

This is the email verification script im using..

//email verify
$activationKey =  mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand();
$sql="INSERT INTO account_info (activation_key, status) VALUES ('$activationKey', 'verify')";

if (!mysql_query($sql)){

exit('Error: ' . mysql_error());
}

else {



//Send activation Email

$to = $_POST['email'];
$subject = "NarutoRPG.com Registration";
$message = "Welcome to our website! You, or someone using your email address, has completed registration at narutoRPG.com. You can complete registration by clicking the following link:\rhttp://www.arzania.com/verify.php?$activationKey\r\r If this is an error, ignore this email and you will be removed from our mailing list.\r\rRegards,\ narutoRPG.com Team";
$headers = 'From: ashyiscool2@gmail.com' . "\r\n" .
'Reply-To: ashyiscool2@gmail.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
mail($to, $subject, $message, $headers);

//User isn't registering, check verify code and change activation code to null, status to activated on success

$queryString = $_SERVER['QUERY_STRING'];
$query = "SELECT * FROM account_info";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if ($queryString == $row["activation_key"]){
echo "Congratulations!" . " " . $row["username"] . " is now the proud new owner of a NarutoRPG.com account. Login to begin to play.";
$sql="UPDATE account_info SET activation_key = '', status='activated' WHERE (id = $row[id])";
if (!mysql_query($sql))

{

        die('Error: ' . mysql_error());

  }

    }

  }
}
}



include "footer.php";
?>

For some reason, when the person is registered it shows everyones name who registered, for example..

You've been successfully registered!Congratulations! tonyhh is now the proud new owner of a NarutoRPG.com account. Login to begin to play.Congratulations! tonyh is now the proud new owner of a NarutoRPG.com account. Login to begin to play.Congratulations! tony is now the proud new owner of a NarutoRPG.com account. Login to begin to play.etc...etc..

How can you make it only repeat the users name who registered, not everyone?

Why does this code only display 1 result? If I PRINT $row3 all results diplay, but the variable will only give 1 result. It would be easier for me to just PRINT row3, but I have 13 rows with different loops.

Code: [Select]
$sql = "SELECT * FROM $city WHERE SG_Name='$sg GROUP BY ID'";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
$ID="{$row[3]}";

}
print
"<tr border='1'>
<td>".$Source_ID."</td>

</tr>";

I am trying to loop through a filtered table.  

This is the code of the loop:

$result = mysqli_query($con,$sql);
$num = mysqli_num_rows($result);
$row = mysqli_fetch_array($result);
$i = 0;
$prebidder = $row['buser'];
mysqli_data_seek($result,0);
while($row = mysqli_fetch_array($result)) {
$buser = $row['buser'];
$itemno = $row['biditem'];
$price = $row['bidprice'];
$qty = $row['bidquantity'];

$query = "INSERT INTO invoiceitems(invnumber,itemnum,price,quantity) VALUES('$ttinvno','$itemno','$price','$qty')";#,unix_timestamp())";
mysqli_query($con,$query);

if ($prebidder != $buser) {
     $ttinvno= $ttinvno +1;
  }
$prebidder = $buser;
 $i++;

}

?>

The filtered data has 55 rows of which 28 are unique.  I am trying to loop through so that the names ($buser) match the invoice number ($ttinvno).  I have the rows indexed on buser descending.

But the rows don't seem to want to match correctly.  The invoice numbers go in sequence correctly but for instance the first two rows have the same name.  But no matter what I have done in this format either the invoice number changes after the first row, or it changes after the third row.  I want it to change after the second row.  I have tried multiple ways including prematurely defining row and then using mysqli_data_seek($result,0); to reset the result before the loop.

Obviously there is a flaw in my code.   Can anyone help?  Thanks very much in advance!