Looping through MySQL rows

[compstudent]

Hi,

I have table where there are 4 columns like seen below.
_____________________________________

Option 1 || Option 2 || Option 3 || Id ||

name--------------------------------3
--------------name------------------6
name---------------------------------8
---------------------------name------9
____________________________________

When I enter the results (which option is correct later) I want to go through all the names in that column and retrieve it, put the query to the users table, then add points to them in the users table. The Id's won't be in order, since some will be deleted then new ones added. I am not sure how to go through and find all the names in a particular column.

Thanks

Matthew

[DemonWasp]

SELECT [Id],[Option 3] FROM [table] WHERE [Option 3] NOT NULL;

[compstudent]

Thanks, Figured it out, needed to also set values in table to null.