Join tables on Oracle using OCI8

[dam72]

I have a problem performing a join query on Oracle tables : using the same functions to connect and execute these queries, the first one never returns any rows, while it does using SQLPlus. The second, that has no joined tables, works fine.

$getUser = "SELECT u.user_name FROM users u, user_rights r WHERE u.user_id = r.user_id AND u.user_id = 2";

$getUser = "select u.user_id from users u where u.user_id=2";

Does somebody has any idea ?

Thanks a lot,
Damien

[fox_m]

Yeah i have an idea....

the user_ids doesnt match that why you get no rows back.

[dam72]

I think the problem is more complicated
Maybe i wasn't very clear (I'm french after all) : both queries work when sent with SQLplus but only the second one does using the OCI8 functions with PHP.
The joined rule is not the problem I think

Damien