Hello all,
I have a MySQL database and have made several search and results pages with Dreamweaver, but I am stuck with a problem. I have a table called materials, In this table I have the following fields, Title (A description of a location where the item is for), Job_No (A filed that is common through out the database and a material item is attached to the Job_No), Quantity (SPeaks for itself, but is the amount of items used), Unit_Price (A cost per item), Additional_Cost (Is the selling cost per item as a percentage i.e. 20% 10% and so on).
In Dreamweaver, I have created a recordset from the table required (material) and if I go to the advanced setting I cna enter the following,
SELECT Quantity * Unit_Price
FROM material
WHERE Job_No = 'colname'
This then gives me the total of the materials used against a selected Job_No and displays it into a dynamic Table. The problem comes when I want to automatically add the percentage from the Additional_Cost.
If I go into the database using MyPHPAdmin and enter,
SELECT QuantityUnit_Price+(QuantityUnit_Price*Additional_Cost/100) FROM material
WHERE Job_No = 1000980, it works, and I get the main total, but, if I put this code into dreamweaver,
SELECT QuantityUnit_Price+(QuantityUnit_Price*Additional_Cost/100)
FROM material
WHERE Job_No = 'colname'
it wont work. My space in the Dynamic Table is blank?
Can anybody please help?
Cheers
Paul.