homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

modifying values in MySQL

Msg#: 4235477 posted 12:17 am on Nov 27, 2010 (gmt 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



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

Msg#: 4235477 posted 5:09 pm on Nov 29, 2010 (gmt 0)

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?


Msg#: 4235477 posted 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.
thanks for all your help

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved