Query runs in MySQL Workbench but not running in mysql_query() in php

Question

select t1.* 
from bbs_product as t1, bbs_category as t2 
where 
(((t1.product_name_de like '%13"%') or 
(t1.sku_number like '%13"%') or 
(t1.description like '%13"%')) and 
((t1.product_name_de like '%Laptoptasche%') or 
(t1.sku_number like '%Laptoptasche%') or 
(t1.description like '%Laptoptasche%')) and 
((t1.product_name_de like '%im%') or 
(t1.sku_number like '%im%') or 
(t1.description like '%im%')) and 
((t1.product_name_de like '%Buchdesign%') or 
(t1.sku_number like '%Buchdesign%') or 
(t1.description like '%Buchdesign%'))) and 
(t1.category_id=t2.id and t2.status=1) and 
t1.status=1 and 
t1.discontinued='no' and 
t1.is_secret='n'

Which error does it produce in mysql_query?

Quassnoi
– Quassnoi

2011-07-20 12:34:54 +00:00
Commented Jul 20, 2011 at 12:34 — Quassnoi
– Quassnoi, Commented Jul 20, 2011 at 12:34

Quassnoi · Accepted Answer · 2011-07-20 12:35:42Z

4

t1.sku_number like '%13"%') or 
(t1.description like '%13"%')) and

You have double quotes in your query text.

Make sure they are properly escaped in the PHP string which is the argument to mysql_query.

answered Jul 20, 2011 at 12:35

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query runs in MySQL Workbench but not running in mysql_query() in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related