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

    Join Date
    Feb 2000
    Location
    Milton, Ontario, Canada
    Posts
    4
    Rep Power
    0
    Is there any way to change some of the values inside a table without replacing all of the information. For instance if a price changes on one item, can I change that one field using PHP and MySQL or do I rewrite the text file and replace the whole thing? Thanks for the help.
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    Hi,

    you can change a field value with out changing all the values in a table.

    Just use an update statement for getting this.

    "UPDATE TABLE TABLENAME SET PRICE=1000 WHERE ITEM='item1'";



Similar Threads

  1. paginating data w/ inner table joins
    By neo100101 in forum PHP Development
    Replies: 5
    Last Post: November 19th, 2003, 06:36 AM
  2. archiving data into another table
    By muinujnik in forum MySQL Help
    Replies: 0
    Last Post: November 15th, 2003, 09:18 PM
  3. Replies: 0
    Last Post: August 1st, 2003, 11:41 PM
  4. Reading member data from sepearate table
    By Keiichi in forum MySQL Help
    Replies: 2
    Last Post: December 24th, 2002, 12:59 AM
  5. transfer data from an xls spreadsheet into a table
    By yoshimitsu in forum PHP Development
    Replies: 2
    Last Post: January 21st, 2002, 08:59 PM

IMN logo majestic logo threadwatch logo seochat tools logo