Forum Moderators: open

Message Too Old, No Replies

modifying values in MySQL

         

magneto

12:17 am on Nov 27, 2010 (gmt 0)

10+ Year Member



Hi,

Is there a way to automatically modify values in a database.

For example, lets say my form stores 3 values,
Value1 = 4000
Value2 = 5000
Value3 = 6000

Now, what i need is for the number 4000 to become "Cost", value2 to be "Expenses" etc. Ideally, if there is a way to modify those values as soon as they are entered, that way i can retrieve them right away.

is there such a thing? Thanks

LifeinAsia

5:09 pm on Nov 29, 2010 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



Not quite sure I understand what you are asking...

Am I right in assuming the following?
1) You have a form with 3 text boxes where the user enters data called Value1, Value2, and Value3.
2) You have a database table with fields named "Cost" and "Expenses."
3) You are asking how to take the data entered in the form and modify the existing values in your table.

Is that correct?

magneto

7:51 am on Dec 3, 2010 (gmt 0)

10+ Year Member



i created a new thread to explain my question differently. please click here to see it.
[webmasterworld.com...]
thanks for all your help