Query using letter not working ??

Hello everyone

I am currently setting up an az-index page which will pull results from my database based on the letter which is passed in the link e.g az_index.php?idx=a, will pull all the items with 'a'

I have a table called azidx with three fields name (azid, name, sub_id). I have a query which says


select * from azidx where azid = $_GET[idx]


this does not seem to work for some reason. If I replace all the instances of the letter 'a', with for example 0. Then call it again using az_index.php?idx=0 it will work.

Any ideas on why it won't work using letter the first way. Do I need to use a certain field type ??
I tried several but no luck. Its not set as a primary key because I have lots of instances of a and b etc but that shouldn't matter.

Any ideas ?? im abit confused ??

:thumbsup:

select * from azidx where azid = '$_GET[idx]'

oh sugggarrrrr

how stupid am I. I was looking at that for ages and couldn't understand why.

:o

Thanks spooks

:thumbsup:

That's a common mistake. :) If you want it to be treated as a string/character then it must be enclosed in quotes. Your letters were probably being interpreted as ascii equivalents so the query would have produced nothing.