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.

    Write a Reply...