If i cosse a result in the drop down and clik on submit it returns the following error:
Error type 256
Error description You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `username`' at line 1
URL intranet/departments/finance/database/auth/orderform_edit.php
Error file C:\Inetpub\wwwroot\newintranet\departments\Finance\Database\auth\include\dbconnection.php
Error line 26
SQL query select , (quant1 unit1) as mycost1, (quant2 unit2) as mycost2, (quant3 unit3) as mycost3, (quant4 unit4) as mycost4, (quant5 unit5) as mycost5, (quant6 unit6) as mycost6, (quant7 unit7) as mycost7, (quant8 unit8) as mycost8, (quant9 unit9) as mycost9, (quant10 unit10) as mycost10, ((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery) as totalnovat, (case when vatfree=1 then 0 else ((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery) 0.175 end) as mvyat, ((quant1 unit1) + (quant2 unit2) + (quant3 unit3) + (quant4 unit4) + (quant5 unit5) + (quant6 unit6) + (quant7 unit7) + (quant8 unit8) + (quant9 unit9) + (quant10 unit10) + delivery )*(case when va