Query issue - Works in Navicat, works in PhpMyAdmin, bombs in PHP

[pblancher]

I am trying to execute the following MySQL query in PHP.

SELECT navigation.id,navigation.pagename_e,navigation.parent FROM navigation WHERE navigation.url ='/test' AND navigation.filename_e = 'index_e.php'

PHP returns 0 rows.

When I execute this query in Navicat for MySQL, 1 row is returned.
When I execute this query in the SQL window of PHPMyAdmin, 1 row is returned.

I edited the query, removing the "navigation.url ='/test' " condition, and the query works right. But I need the navigation.url condition.

Could this be because of the forward slash at the beginning of the field? If so, how do I take care of it so I can use it?

TIA,

Phil

[subwayman]

I don't think so as mysql uses backslash for escape sequences. However, have a look at the actual content of the url column in your database. Perhaps something has happened to the data going in.

If the url column always starts with / then try

SUBSTRING(navigation.url) ='test'

[Najjar]

Can you post the PHP code where you have the query?