SQL works in PHPMyAdmin but not in PHP

Cribby001

Hi,

I have the sql statement "Select * from MyTable Where Field Like "%ABC/DEF%" which works as expected using PHPMyAdmin yet when the same sql statement is run using php on the web it doesn't return anything. I know that this must be related to the forward slash but I have been unable to resolve the problem.

In the data table there is only one forward-slash. (eg ABC/DEF)

Any help would be gratefully appreciated.

Cheers,

Chris

paulnaj

Hi I assume you mean:

Select * from MyTable Where Field Like "%ABC/DEF%"

rather than ...

"Select * from MyTable Where Field Like "%ABC/DEF%"

... since the the second won't work in phpMyAdmin or in a script.

This should work:

mysql_query('Select * from MyTable Where Field Like "%ABC/DEF%"');

If not, show us the exact PHP snippet of code you are using to run the query (including connection code - minus any sensitive info like passwords of course)

Paul

Cribby001

Hi,

Thanks for the rapid response. I have printed the sql string and it shows

SELECT * from jobs where status like '0' and category like '%Managers Care/Nursing Homes%' order by jobid desc LIMIT 0, 10

The problem would appear to be that the actual category data is
Managers - Care/Nursing Homes
and the dash is being left out of the SQL.

How can I overcome this, I would rather not have to change the category text as this is what the users see.

Cheers,

Chris

paulnaj

Hi,

It's going to be hard to get help without some solid details ...

Show the CREATE TABLE statement and some sample data (use phpMyAdmin to export the table)
Show the PHP statements you are using to run the query.

Paul