It still dosen't work.
I think i give up..

There's an old saying...

"Winners never quit, and Quitters never win"

Don't just copy and paste everything, read through, check it through...

You will find, that people will help, but they won't do it for you...

__________________
Thanks... Simon

Yes i know..
I have just nearly tried everything.

Is it normal that the UPDATE string is so difficult to get working?

In order for you to become a better PHP developer you need to actually understand what is going wrong, like the post above suggests myself or someone else doing it for you won't help you in the long run.

We must start by logically looking at the problem.

1. PHP isnt complaining anymore, so PHP syntax error isnt at fault and our program flow doesnt look to be at fault
2. MYSQL doesn't seem to find a problem with the syntax of our SQL, otherwise mysql_query would have returned false and thus mysql_error() would have been fired.

so we must now think about the data passed into the SQL, is that where the problem is? does the id you are testing against in the WHERE clause actually exist in the db?

Clue: mysql_affected_rows();

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)

Another clue is look at the form source (in the browser), check what the variables are called and see if you can find the error :D

__________________
Thanks... Simon