PLEASE HELP - URGENT!

[Anon]

i know its confusing.

On the first page i have nine rows PULLED/TAKEN from the database.

All called $skill

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

So it gets how many rows in the database where the column header is skill!

Skill_001
Skill_002
Skill_003
Skill_004
Skill_005
Skill_006
Skill_007
Skill_008
Skill_009

The problem is because it is doing it by pulling it from the database, they ALL have ONE (1) value.

The next page

Select * from skill WHERE last_page_value = \"$skill\"

so they all have 1 value. It seems to be overwriting each row at a time and only passes over the last row, but i need ALL 9 if thats how many are in the database.

Hope this helps you understand more.

Thank you VERY Much.

Adam

[Anon]

Look at your code! What will $skill have when this loop finishes? Only "SKILL_0009" from the last row!

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

If you need all nine values, build an HTML table and pass all 9 of them to the second page as form INPUT fields, don't keep cramming them all into the one variable; of course it overwrites the first eight, what did you think it would do?