Editting and replacing selected data in MySQL

[Rockonmetal]

I am trying to make account options for my site. I don't know how to have it so that the user can change their options. I only know how to select, insert, and delete.
I don't know the script to do this so if someone could provide the whole thing so that I can learn what is going on. Thanks

[thetestingsite]

Have a look at the following:

http://www.php-mysql-tutorial.com/mysql-update-and-delete.php

Hope this helps.

[boogyman]

I wouldnt' give the user delete permissions. there is no confirmation, and the only "restore" is if you created a backup

so if you do decide to create some type of delete functionality for your site make sure its limited, and before you even delete something double check thats what you want to delete.



DELETE FROM table WHERE condition;


http://dev.mysql.com/doc/refman/5.0/en/delete.html