从DB中返回的值设置PHP变量

Question

Newbie to PHP and trying to learn it. I have returned data from my DB.

So the rows may look something like below

ID--------Name--------PhoneNo
1         Joe         1234
2         Jane        5678
3         Tom         0000

I am using the msql_fetch_array to return the data as below:

    <?php
            while($row = mysql_fetch_array($result))
            {
                $NameOne = $row['Name'];
            }
    ?>

This is placing the name 'Joe' in the variable name NameOne as expected. What is the best way however to get Jane and Tome into variables called $NameTwo and $NameThree that I can then echo these variables further down in my html and similary I want to place the phone number retrieved into seperate variables and refer to them later in my html.

Answer 1

The ideal approch will be saving them inside an array, which can be achieved like this:

$Names = array();
$i = 0;
while($row = mysql_fetch_array($result)) {
    $Names[$i] = $row['Name'];
    $i++;
}

Now you can retrieve your data this way:

echo $Names[0]; // Will output the first name saved.