Welcome to WebmasterWorld Guest from 54.205.209.95

Forum Moderators: open

Message Too Old, No Replies

modifying values in MySQL

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



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
5:09 pm on Nov 29, 2010 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ 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?
7:51 am on Dec 3, 2010 (gmt 0)



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