Closed

FIX PHP CODE ERRORS FOR PRICING CALCULATOR

This project received 25 bids from talented freelancers with an average bid price of $125 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
25
Project Description

My pricing calculator is not working properly, and I need it fixed. Attached is the PHP file. When I run the PHP file in Firefox from WAMP I get the following errors.

( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 ' in C:\wamp\www\EMPIRE\lib\Zend\Db\Statement\[url removed, login to view] on line 234
( ! ) PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'BETWEEN `quantity_from` AND `quantity_to`' at line 4 in C:\wamp\www\EMPIRE\lib\Zend\Db\Statement\[url removed, login to view] on line 228
Call Stack
# Time Memory Function Location
1 [url removed, login to view] 167280 {main}( ) ..\[url removed, login to view]
2 [url removed, login to view] 5211976 Zend_Db_Adapter_Abstract->fetchCol( ) ..\[url removed, login to view]
3 [url removed, login to view] 5212088 Varien_Db_Adapter_Pdo_Mysql->query( ) ..\[url removed, login to view]
4 [url removed, login to view] 5212312 Zend_Db_Adapter_Pdo_Abstract->query( ) ..\[url removed, login to view]
5 [url removed, login to view] 5212312 Zend_Db_Adapter_Abstract->query( ) ..\[url removed, login to view]
6 [url removed, login to view] 5213768 Zend_Db_Statement->execute( ) ..\[url removed, login to view]
7 [url removed, login to view] 5213768 Varien_Db_Statement_Pdo_Mysql->_execute( ) ..\[url removed, login to view]
8 [url removed, login to view] 5213800 Zend_Db_Statement_Pdo->_execute( ) ..\[url removed, login to view]
9 [url removed, login to view] 5213832 execute ( ) ..\[url removed, login to view]
( ! ) Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'BETWEEN `quantity_from` AND `quantity_to`' at line 4 in C:\wamp\www\EMPIRE\lib\Zend\Db\Statement\[url removed, login to view] on line 234
Call Stack
# Time Memory Function Location
1 [url removed, login to view] 167280 {main}( ) ..\[url removed, login to view]
2 [url removed, login to view] 5211976 Zend_Db_Adapter_Abstract->fetchCol( ) ..\[url removed, login to view]
3 [url removed, login to view] 5212088 Varien_Db_Adapter_Pdo_Mysql->query( ) ..\[url removed, login to view]
4 [url removed, login to view] 5263504 Varien_Db_Adapter_Pdo_Mysql->_debugException( ) ..\[url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online