[RESOLVED] Concat problem (backslashes added to query)

2005

Is there any way how to remove backslashes from query with concat and additional characters between selects?

When I run:
SELECT CONCAT(city,' - ',total_number) FROM table...

the query transforms to:
SELECT CONCAT(city,\' - \',total_number) FROM table...

and doesn't return any results.

Thanks.

laserlight

hmm... as in your are sending your queries through a form, and then executing them? It is not a good idea unless you secure that form.

The problem is that magic_quotes_gpc is set to on. Disable that configuration setting in php.ini and restart your webserver. If that is not feasible then use [man]stripslashes/man to remove the slashes. You might want to test with [man]get_magic_quotes_gpc/man before using stripslashes() so as to make your script work regardless of magic_quotes_gpc setting.

2005

laserlight, thank you for your reply. No, I am not sending queries through form. I had a problem to customize: Ajax Linked Select boxes script
http://www.salix.gr/ajax_linked_selectboxes

I added concat and the script didn't return any results from DB. Then I discovered that it's due to backslashes in MySQL query.

Stripslashes resolved this problem.