Professional Web Applications Themes

Help in keep records while updating the records - MySQL

Hi friends I need Help in keep records while updating the records. My prob is that i cant able to keep the version of records. i m working on a website project. For that purpose we hav to keep the version of records. each time update the record it will update it that for sure but it will also keep the duplicate cate copy of the record tht is being updated. in out table we have "ID" as primery key and "version" as another unique key I m trying that when ever i update the record it will keep the ...

  1. #1

    Default Help in keep records while updating the records

    Hi friends

    I need Help in keep records while updating the records. My prob is that
    i cant able to keep the version of records. i m working on a website
    project. For that purpose we hav to keep the version of records. each
    time update the record it will update it that for sure but it will also
    keep the duplicate cate copy of the record tht is being updated.
    in out table we have "ID" as primery key and "version" as another
    unique key
    I m trying that when ever i update the record it will keep the backup
    of the record is being updated and also updates the record.
    the updated record has updated on the "version" field nt the "ID" field

    jasvaran Guest

  2. #2

    Default Re: Help in keep records while updating the records

    jasvaran wrote: 

    So, don't UPDATE the row. INSERT a new one.

    --
    File not found: (R)esume, (R)etry, (R)erun, (R)eturn, (R)eboot
    Pedro Guest

Similar Threads

  1. Updating records in a database (php)
    By EliDee in forum Dreamweaver AppDev
    Replies: 18
    Last Post: June 28th, 05:16 PM
  2. Updating Multi records
    By rddave51 in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 10th, 04:37 PM
  3. Updating database records in a datagrid
    By EmJayEm in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: December 23rd, 04:52 AM
  4. Updating records when using a subform
    By M.Lubi in forum Microsoft Access
    Replies: 0
    Last Post: July 23rd, 08:44 PM
  5. Updating Multiple Records
    By Jordan Marton in forum Macromedia Dreamweaver
    Replies: 5
    Last Post: July 10th, 08:40 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139