PHP/MySQL Select with Special Characters not working


I have a PHP 5.3 program, and I am trying to do a select like this:

SELECT nto_category_id FROM store_product_import_categories WHERE store_category = 'BARS_&_BARSTOOLS'.

I can do the same select in PHPMyAdmin, but in MySQL, I cannot get it to give any results. I believe it is because of the & sign or _ characters. I am not sure...

The database table is a simple UTF8 table. I am not sure what the problem could be. I need somebody to help me write this PHP program and get this select statement working properly. Please let me know if you are interested and I will send you the program to take a quick look.



Skills: MySQL, PHP

See more: what is the problem statement, what is problem statement, what is a problem statement, program problem statement, select, mysql characters, mysql select statement, write simple php database, mysql help table, extjs select mysql php, phpmyadmin mysql, problem statement need database, php mysql statement, simple sign sign php database, php mysql quick, mysql statement, simple sign database php, chained select mysql php, simple sign mysql, simple program php mysql

About the Employer:
( 25 reviews ) Atlanta, United States

Project ID: #5480996

32 freelancers are bidding on average $302 for this job


Dear Sir, We would love to get this opportunity of working with you. We can guarantee complete satisfaction if you select us to execute this project. Regards NetzPro

$257 USD in 1 day
(374 Reviews)

A proposal has not yet been provided

$263 USD in 1 day
(770 Reviews)

Hi, Expert team here to help you. Could you please provide files and db schema? Looking forward to hear from you. Regards,

$252 USD in 10 days
(233 Reviews)

Hi, I'm interested to work on your project. Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

$257 USD in 2 days
(454 Reviews)

Hi Sir, I am ready to work for you.I have 9 years of experience in java, php, javascript, wordpress, .NET, c# and, MySQL etc.. please see some of my works also check my reviews you will get better idea about my skill. More

$250 USD in 2 days
(115 Reviews)

hi, my name is shahid, i am working in web development from past four year. Surely will provide you quality work and we will have long term relationship in web development.

$250 USD in 3 days
(519 Reviews)

Hi, Iam interested in your project and I'll be happy to do that for you. here are examples of work: [login to view URL] [login to view URL] [login to view URL] I am ready to work with More

$515 USD in 10 days
(46 Reviews)

Hi, Based on the description you've posted, the problem should not take long to resolve, and is likely caused by how you are performing the select in PHP. I'd be happy to assist you in resolving this issue and gett More

$250 USD in 1 day
(67 Reviews)

Hello, I am interested to work for this project and I will provide you within or before 2 days . Of course, I know you could be in doubt about my real ability. It would be important for me to prove my ability throug More

$263 USD in 2 days
(94 Reviews)

Our Brief Profile: Websalvia Solutions has more than 9 years of experience of developing database driven websites and applications. Our Services are but not limited to Template design, Logo creation, Banner design, More

$250 USD in 3 days
(108 Reviews)

Hi I have checked your project requirement. Please accept the bid. I can give you the solution for the problem. Thanks Shihan

$277 USD in 1 day
(317 Reviews)

Hello, I am experienced PHP and MySQL developer and I will check the problem and fix it for you. Please send to me the program to get a better idea about the problem you are having. Thanks, John

$250 USD in 5 days
(75 Reviews)

Hello Sir, I thoroughly read your project description. I have to re-evaluate my bid according to the extra details about your project. I have an extensive experience with php/mysql + jquery and more(json, xml, ap More

$250 USD in 1 day
(15 Reviews)

Hello. Yore right: symbol & seems to be a reason of the error. But not a fact yet. Let me see code please, sure I will help you quickly

$250 USD in 1 day
(48 Reviews)

Hello, Read the problem you face in php script Please provide a script and databaase for check Waiting for your reply Regards, Twinkle

$250 USD in 2 days
(26 Reviews)

hi, I am Adams, a full time freelancer procient in php/ajax/MYSQL. I will fix the query for you. Lets start, Thanks

$250 USD in 10 days
(85 Reviews)

Hello Sir, I am very much interested to solve Your problem. If You provide table structure with 2/3 sample record or if You connect with me via teamviewer then I will solve that immediately. If You want I will do th More

$250 USD in 1 day
(47 Reviews)

Looking for a dedicated person who can make you job done? I've developed a lot of Web Portals, Web Applications, and Business CMS etc. The areas of expertise that we have are: - PHP & MySQL - .Net Technology - C#/ More

$622 USD in 17 days
(9 Reviews)

I can start right now see some of the responsive websites i have prepared : [login to view URL] [login to view URL] [login to view URL] and many more. I am html5 and php expert. i can start right now

$250 USD in 1 day
(15 Reviews)

Greetings, I do have plenty of experience with MySQL + PHP, and I am pretty good at fixing glitchy code. Once awarded the project, I will be needing the PHP code, as well as a proportion of the database dump (i.e More

$270 USD in 2 days
(8 Reviews)