Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

modifying values in MySQL

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

New User

5+ Year Member

joined:Sept 3, 2010
posts: 16
votes: 0


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)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
votes: 76

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)

New User

5+ Year Member

joined:Sept 3, 2010
posts: 16
votes: 0

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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members