MySQL Forums
Forum List  »  Knowledge Base

Incorporating data from two tables
Posted by: Simon Emms
Date: February 11, 2009 05:56PM

Hi there

This is a problem that's been bugging me for ages.

I'm currently writing an FAQ/knowledgebase for an ecommerce site I'm doing. The FAQ I've set it "how much does it cost?". Now, this figure (which is a percentage figure, currently 15%) might change in the future.

In the admin table, one of the fields controls what that percentile figure is. I want that to appear in the answer to this FAQ. In human-speak, it would be "the cost of this service is '%FIGURE-TAKEN-STRAIGHT-FROM-ADMIN.ID.5%'".

Anyone out there know how I can do that?

Thanks

Simon

============================
http://www.real-ale-shop.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Incorporating data from two tables
3425
February 11, 2009 05:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.