Member Avatar for ceeandcee

I would like to query a set of values from a db....say GP1011_wk1 and this would yield 11 results. I then sum them together and get a value that i can echo. No problem so far.

My question is, can i now take this calculated value from the query and automatically update it into another table?

Any help would be appreciated

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 19 Hours Discussion Span
  • Latest Post Latest Post by chrishea
Member Avatar for chrishea

Assuming that "automatically" means doing a query to write it to another table, then the answer is yes. Do a MySQL Insert or Update into the appropriate table.

commented: Thank you! +1
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.