mysql按顺序取固定数组里的数字,MYSQL-从读取的数组中选择特定值

I have a small problem and since I am very new to all this stuff, I was not successful on googling it, because I dont know the exact definitions for what I am looking for.

I have got a very simple database and I am getting all rows by this:

while($row = mysql_fetch_array($result)){

echo $row['id']. " - ". $row['name'];

echo "
";

}

Now, my question is: how do I filter the 2nd result? I thought something like this could work, but it doesnt:

$name2= $row['name'][2];

Is it even possible? Or do I have to write another mysql query (something like SELECT .. WHERE id = "2") to get the name value in the second row?

What I am trying to is following:

-get all data from the database (with the "while loop"), but than individually display certain results on my page. For instance echo("name in second row") and echo("id of first row") and so on.

解决方案

If you would rather work with a full set of results instead of looping through them only once, you can put the whole result set to an array:

$row = array();

while( $row[] = mysql_fetch_array( $result ) );

Now you can access individual records using the first index, for example the name field of the second row is in $row[ 2 ][ 'name' ].