SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard
    Join Date
    Apr 2004
    Location
    dublin
    Posts
    2,036
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Overwriting Existing Table Data

    Morning all,

    I insert data from a html form into a database table.

    How do I ensure that each time I enter data it will overwrite/replace the existing table data?

    thanks,

    Kevin.

  2. #2
    SitePoint Enthusiast jpatterson's Avatar
    Join Date
    Jun 2005
    Location
    Birmingham, UK
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can use the UPDATE Statement. Here's some information:

    http://www.w3schools.com/sql/sql_update.asp

  3. #3
    SitePoint Wizard
    Join Date
    Apr 2004
    Location
    dublin
    Posts
    2,036
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks jpatterson. I see your from Birmingham. Great city. Villa fan?

  4. #4
    SitePoint Enthusiast jpatterson's Avatar
    Join Date
    Jun 2005
    Location
    Birmingham, UK
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes I am a Villa Fan. You're from Dublin? I take it you've visited Birmingham then? Hope you liked it.


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
  •