Hello all, I found this forum through Google, and I have searched through a load of pages, but I cant seem to find what I need, I did see one part about changing the DATETIME to just DATE and that worked, but, here is my problem.
I have a MySQL database and using Dreamweaver I can create a HTML page with a search box. In the Search box I enter a job number i.e. KN1234 and press submit. I now get a php page with brief details on it about the job number. I now click on the description of the job, and I now go to a results.php page with all the info about that job number. I have several recordsets that display the job order, the person who went to the job, the amount of time spent on the job and any materials used. I now have this problem, I have a table called material, in this table, I have the various fields, Job_No, Quantity, Unit_Price, Additional_Price and Description. Now, in PHPMyAdmin if I put something like;
SELECT Quantity * Unit_Price + (Quantity * Unit_Price * Additional_Cost / 100) FROM `material` WHERE Job_No = 1000980 I get my answer, Additional_Price is a markup on materials it can be anything from 5% to 20% so it is different for each job. If I enter this in my PHP I just get errors.
Please can anybody help. I can do most of the rest such as insert new data and edit exsisting data, I just need to get this so I can start to generate invoices.
Thanks in advance
Paul.
