How to access the mysql_fetch_array function output outside of the while loop...?

Question

I am trying to access the $Frined_Id outside the while loop. But it is only returning the last accessed element. Is there any method so that i can store the value of Friend Id inside the array and then can use them in program whenever i want.

$query="SELECT * FROM `user_friend` WHERE `User_Id`='$id'";
if($query_run=mysql_query($query))
    {
    $mysql_num_rows=mysql_num_rows($query_run);
    $i=$mysql_num_rows;
    while($row=mysql_fetch_array($query_run))
        {
            $Friend_Id=$row['Friend_Id'];
            $Name=$row['Friend_Name'];
            $Name_array=array("$Name");
            echo "<a href=\"view_profile.php?id=$Friend_Id\"/>".$Name."</a>".'<br>';

        }
        echo $Friend_Id;
}

Jeremy Harris · Accepted Answer · 2012-02-23 17:05:54Z

1

The reason it only shows the last one is because it gets changed each time in the loop and the last thing it was set to is what it is. A fix for being able to access all of them is make $Friend_Id an array as such:

$Friend_Id[] = $row['Friend_Id'];

Then after your loop, you can access them by index

// Show the first one
echo("Friend ID is " . $Friend_Id[0]);

// Show the third one
echo("Friend ID is " . $Friend_Id[2]);

You can make it even more useful by making an associative array containing the name and id like:

$friend[] = Array($Name => $Friend_Id);

Just a few ideas...

answered Feb 23, 2012 at 17:05

Jeremy Harris

24.7k13 gold badges84 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Captain Insaneo · Accepted Answer · 2012-02-23 17:14:41Z

0

If you're only getting one result (if the ID is unique), don't use a loop at all.

$query = "SELECT * FROM 'user_friend' WHERE 'User_Id'= $id LIMIT 1";
$row = mysql_fetch_array($query_run);
...
echo $row['Friend_Id'];

Then you don't have to worry about if the value is only available inside the loop.

answered Feb 23, 2012 at 17:14

Captain Insaneo

4702 silver badges7 bronze badges

Collectives™ on Stack Overflow

How to access the mysql_fetch_array function output outside of the while loop...?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related