A Difficult Query!

[Anon]

Hi, I have a problem which I would be most greatful if someone could help me with.

I have an SQL query and after WHERE I am tring to JUST get the first character a from the column "NavID" on each row. Then I need it to be checked against another variable.

E.G (this won't work)

WHERE substr(NavID, 0, 1) = $MenuHighlight

[amcgrath]

are you putting single quotes around $MenuHighlight' ?

ie WHERE substr(NavID, 0, 1) = '$MenuHighlight'

[[deleted]]

also, if you are using mysql, then a string begins at position 1, not at position zero as in PHP.

[Anon]

Thank you both of you!

[Anon]

Gah, it won't work still... Yes I am using ''

[vsego]

Maybe character case is different?

[Anon]

Nope =(

[[deleted]]

What is your exact query now?

[vsego]

And what do you get when you call
echo "\"$MenuHighlight\"";

[mickro]

Krakken,

Try using 'substring' instead of 'substr':

WHERE substring(NavID, 1, 1) = '$MenuHighlight'

HTH

Mike

[Anon]

Okay I will thanks.
YAY! It works! Thanks a LOT!