Results 1 to 2 of 2

Thread: Update record

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    259

    Update record

    I have table it's name Members contain this field (ID,username,Number)

    How can I go to the recode that it's ID=4 and add 1 to Number

  2. #2
    Fanatic Member nabeels786's Avatar
    Join Date
    Jul 2001
    Location
    New York
    Posts
    919
    PHP Code:
    $sql "UPDATE members SET id = id + 1 WHERE id = '4'"
    if you are adding members in, and want to increment the id everytime you add one, just set the 'id' field to auto increment
    Visit www.fragblast.com
    Gaming, forums, and a online RPG/Battle system




    (__Flagg) DOT NET? is this a Hindi Dating service?

Posting Permissions

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



Click Here to Expand Forum to Full Width