php query to mysql database

[keiron77]

Is there a way to have a url which when clicked will set a record from yes to no?

I have:

<?

$registered = "yes";
if ($registered == $userdata['newsletter']) :
echo "yip";
else:
echo "nope";
endif;

?>

And all i need is a url that will turn a record from yes to no in the first echo (to replace yip) and no to yes in the second echo (to replace nope).

The field is located with table freedom_forum_users field newsletter.

I'm sure its quite easy to do, i just cant think how.

[gordonrp]

use a query string to pass the data in the link to another page which updates the field and then displays "done" or whatever.

this should help:
http://phpbuddy.com/sub_articles.php?other_articles=12

or use a form to submit the data to the same page

gp