SQL string not working once in PHP code :-(

[fabiuz]

Hallo,

may be it is late.... but I am becoming crazy because I am trying to write a MySQL query that is working directly but not if I put in my PHP code ...

The query is:

SELECT key FROM table WHERE INSTR('$var', key)

where key is the name of a field

When I put this string in PHP I see that the last field is not replaced with the value in the table but it is left as the word "key"

while if I pass this query directly to MySQL it works perfectly !

Anybody could help to understand why once in PHP my SQL is missunderstood ?

thank you very much!

Fabi

[hand]

SELECT key FROM table WHERE INSTR('$var', 'key')

[[deleted]]

"When I put this string in PHP I see that the last field is not replaced with the value in the table but it is left as the word "key""

And what makes you think it should be replaced by anything at all?