Results 1 to 3 of 3

Thread: Editting and replacing selected data in MySQL

  1. #1
    Join Date
    Jan 2007
    Location
    The stage
    Posts
    568
    Thanks
    23
    Thanked 6 Times in 6 Posts

    Default Editting and replacing selected data in MySQL

    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

  2. #2
    Join Date
    Sep 2006
    Location
    St. George, UT
    Posts
    2,769
    Thanks
    3
    Thanked 157 Times in 155 Posts

    Default

    Have a look at the following:

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

    Hope this helps.
    "Computer games don't affect kids; I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music." - Kristian Wilson, Nintendo, Inc, 1989
    TheUnlimitedHost | The Testing Site | Southern Utah Web Hosting and Design

  3. #3
    Join Date
    Jul 2006
    Location
    just north of Boston, MA
    Posts
    1,806
    Thanks
    13
    Thanked 72 Times in 72 Posts

    Default

    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.

    Code:
    DELETE FROM table WHERE condition;
    http://dev.mysql.com/doc/refman/5.0/en/delete.html

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •