#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    13
    Rep Power
    0
    Hi everybody...

    I need to modify record.pls tell me how....
  2. #2
  3. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    16
    Please be more specific!

    However you can modify a record like this using SQL:

    UPDATE (tablename) SET (column_name) = '(Original_Name)' WHERE (column_name) = '(New_Name)';

    The pieces in brackets you'll have to replace with something of your own. This will modify ALL the records whose names are Original_Name and change the name to New_Name

    -------------------------
    Alex
    (http://www.alex-greg.co.uk)
  4. #3
  5. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    Actually, Alex, you got that backwards. The way you have written the query it will change column_name to original_name where column_name = new_name
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    London
    Posts
    46
    Rep Power
    14
    Let's say that you have a table called "table1", which has a column called "column1".

    In this column you want to update all rows containing the value "Value1" in "column1" to contain the value "Value2"

    UPDATE table1 SET column1='Value2' WHERE column1='Value1';

    Kelvin

    [This message has been edited by releasedj (edited June 21, 2000).]
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    13
    Rep Power
    0
    how if the value we going to change is a string...

Similar Threads

  1. PHP update record selects the first record only
    By dwmartin in forum PHP Development
    Replies: 11
    Last Post: October 7th, 2003, 03:48 PM
  2. Spotlight record delay
    By Harle in forum PHP Development
    Replies: 3
    Last Post: June 1st, 2003, 05:11 PM
  3. Hiding an empty table or record?
    By UnkFrank in forum PHP Development
    Replies: 1
    Last Post: July 3rd, 2002, 12:19 AM
  4. 'flashing' through divs
    By Roxy in forum HTML Programming
    Replies: 4
    Last Post: April 16th, 2002, 06:15 PM
  5. Replies: 25
    Last Post: March 5th, 2001, 12:35 AM

IMN logo majestic logo threadwatch logo seochat tools logo