Checkout on modified OS-Commerce shop

Completed Posted Mar 12, 2013 Paid on delivery
Completed Paid on delivery

Hi,

On a shop with modified checkout, we have a MYSQL error when there is a quote in the addres or city.

This is the error when a quote is used in the city. Name of city: 's-Gravenwezel

Error:

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 's-Gravenwezel' and customers_id = '522'' at line 1

select address_book_id from address_book where entry_street_address = 'Sint-Jobsteenweg 51' and entry_postcode = '2970' and entry_city = ''s-Gravenwezel' and customers_id = '522'

[TEP STOP]

This is the error when a quote is in the address:

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 'testsstraat 125' and entry_postcode = '8020' and entry_city = 'Oostkamp' and cus' at line 1

select address_book_id from address_book where entry_street_address = 'J' testsstraat 125' and entry_postcode = '8020' and entry_city = 'Oostkamp' and customers_id = ''

[TEP STOP]

HTML MySQL OSCommerce

Project ID: #4324834

About the project

9 proposals Remote project Active Mar 12, 2013

Awarded to:

madeureka

extremely fast fix, i know exactly what is the problem. thank you

$40 USD in 0 days
(13 Reviews)
5.3

9 freelancers are bidding on average $77 for this job

rabbul

Please check PMB

$50 USD in 1 day
(99 Reviews)
7.1
neoconcepts

ready to start.

$50 USD in 1 day
(18 Reviews)
6.4
scriptphp87

Hello Please read more than private message thank you

$200 USD in 3 days
(21 Reviews)
5.5
indianbusybees

Hello, I am ready to fix this issue. Thanks - AKASH-

$30 USD in 1 day
(0 Reviews)
5.1
angelsofttech

Hello sir, I can start work now thanks

$50 USD in 2 days
(7 Reviews)
3.9
corpotec1993

We are interested in assisting you in completing your project as we have the experience that is needed. Thank you for reviewing our bid.

$250 USD in 5 days
(6 Reviews)
3.8
webisyours0602

Good day, OsCommerce expert here. Lets do it.

$50 USD in 0 days
(3 Reviews)
3.8
ebinarylogix

We have 15 years of experience in MySQL and we will get it done with quality - Please see PMB for detail.

$50 USD in 0 days
(0 Reviews)
0.7
EngrNikson

Hi, In response to the job advertisement published in the freelancer.com. I would like to offer myself as a candidate for the post. I am very interested in working on your project. I have experience with Web desig More

$120 USD in 15 days
(0 Reviews)
0.0