FIX PHP CODE ERRORS FOR PRICING CALCULATOR

Closed

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]

Skills: MySQL, PHP, SQL

See more: uncaught exception pdoexception message sqlstate 42000, fatal error uncaught exception pdoexception message sqlstate 42000, wamp with php 5.6, wamp server php, get right code, php pdo, php fatal error, pdo, fix php, fix php fatal, fix mysql query, line calculator, fatal error php, php sql syntax error, 1064 php, error query 1064, php sqlstate 42000 1064, php 42000, fix query, run access function sql, 42000, php fatal error uncaught exception pdoexception message sqlstate, mysql sql function, access 42000, exception pdoexception message sqlstate

Project ID: #5068655

21 freelancers are bidding on average $127 for this job

brycep

Hi, PHP/MySQL expert. It seems compatibility issue. I need Cpanel login details. Waiting for your reply. Thanks!

$175 USD in 5 days
(194 Reviews)
7.7
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$206 USD in 1 day
(465 Reviews)
7.3
kchg

Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you can guess. :) Regards.

$206 USD in 1 day
(66 Reviews)
7.1
scriptphp87

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm alway top in Vietnam freelancer https://www.freelanc More

$154 USD in 3 days
(93 Reviews)
6.7
s17

I have reviewed the file and understand why the problem is happening. i will apply fixes to the code to allow it to continue properly without errors.

$55 USD in 3 days
(342 Reviews)
6.5
programer218

Hello! I have experience in php development. Please look my reviews. If you hire me, I will do my best. Thank you!

$120 USD in 1 day
(30 Reviews)
5.6
digidreamstech

Hi, I have checked your PHP file and errors and I can easily solve this. These errors are related to sql syntax not proper, I had checked the php file and find the code lines, which are not correct. I am PDO exper More

$94 USD in 1 day
(24 Reviews)
5.5
alrazon

Hi, I need to work on this in your server for testing purpose because it needs the database to check the code. Please let me know if you are interested. Thanks.

$50 USD in 3 days
(35 Reviews)
5.3
evidcomm

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

$115 USD in 3 days
(26 Reviews)
5.3
yanotcook

My PHP experience was since I have contributed many osc add-ons since 2006, such as: ( http://addons.oscommerce.com/profile/68072 ) 1) YMM for osc2.3.3 2) CCGV Credit Class Gift Voucher 6.0 v.10.4 for 2.3.3 (backwar More

$73 USD in 3 days
(34 Reviews)
5.1
zo0r

Hi sir! I'm Jorge a Web Developer. I can fix that problem fast. I'm ready to start ASAP. Thanks for your time! Kind regards, Jorge Trujillo - Web Developer, Dieam Inc Team. Some works: ServiPicks More

$50 USD in 0 days
(10 Reviews)
5.0
cmcs

Good day, I have 12 years PHP/MySQL development experience. I will be able to debug and fix this error for you. I am available to start immediately. Regards, Chris

$111 USD in 1 day
(58 Reviews)
4.9
eComOS

Hello tshirtman2009, I have gone through your outsourced requirement "FIX PHP CODE ERRORS FOR PRICING CALCULATOR" and have analyzed that I have right credentials (MySQL, PHP, SQL) to execute your esteemed project. More

$122 USD in 2 days
(47 Reviews)
4.9
SamNanton

I am a native English speaker with over twenty years experience working in various technologies, including mySQL and php. While it's a little difficult to diagnose the problem from the information given, I'm going More

$200 USD in 3 days
(2 Reviews)
4.1
AccuPro

Hello, I can help. I am pretty sure what the problem is, and can resolve it quickly But I will do it at this low price ONLY if you award the job within the next 30 minutes. Best regards, AccuPro.

$277 USD in 2 days
(6 Reviews)
4.1
listmystuff

Hi I have 10+ years developing commercial grade systems primarily using Linux, Apache, MySQL, PHP/Perl and Javascript. I have an in-depth understanding of these areas. I can start on the project now. I was More

$147 USD in 3 days
(4 Reviews)
3.8
szatam

Hey, I can fix this quickly, check my profile for reference feedback and previous experience. Tamas

$60 USD in 1 day
(9 Reviews)
3.4
mediatro

Greetings, error you've posted is really simple and can be debugged quickly given you provide acces to the source and db admin. However I can't grant that everything else works as intended, so that bid is for this e More

$35 USD in 1 day
(5 Reviews)
3.0
iglobalvn

I am php expert . Let me help you solve this issue in max 5 hours . This is database issue . I ready to start right now . Please feel free to ask any questions and we would be happy to assist you. Regards,

$147 USD in 0 days
(5 Reviews)
2.7
lordzardeck

I have worked 6+ years with PHP and MySQL. I can fix this for you very quickly, probably within hours. If you have ANY questions, feel free to contact me.

$83 USD in 1 day
(3 Reviews)
2.7