Hello,
I am fairly new to php and am having problems working out the best way to go
about doing what i want to do.

I want users of my system to be able to choose from a selection of images
which they have earlier uploaded. I am using a system where the picture show is
the one with the number 1 in the `use` colum of a mysql database, only i dont
know how to make it so a user can change that number.

Any help will be greatly appreicated weather that is how to get the above to
work , or ideas of a different system i could use to have the same effect,
thank you,
James

From the problem you're describing, I would set it up like this:

Db1_Table 1 (tbl_Images)

Columns
1) id
2) image_location

Db1_Table 2 (tbl_UserPrefs)
1) id
2) user_name
etc...
x) image_location

So, in your user preferences, use a dynamic drop down. The values will come
from Db1_Table 1.

When the user submits the changes to his preferences, the value from the
dynamic drop down will go into Db1_Table 2.

You'll need to have 2 Recordsets for this to work, of course.

thanks done ,cheers