Overwriting PHP Valubles

[Anon]

Hi,

i have a page that

$sql = "SELECT * FROM skills
WHERE skill_from_last_page = $skill";

i have a

while ($row = mysql_fetch_array($sql_result))
{
$skill2 = $row["skill2"];

}

$skill2

Which brings back 9 rows of $skill2.

Ok, the next page

$sql = "SELECT * FROM skills2
WHERE skill_from_last_page = $skill2";

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

$skill3 = $row["skill3"];

}

but bcos
$skill2 is the same value ($skill2) for each row, it overwrites each row and just selects the last row from the database.

Any help of how to set each value a setting so this will work?

Adam