[RESOLVED] Missing type variable

[dcjones]

Hi all,

I have constructed a query which gives an error. I have played around with it but I still get the same error.

SELECT *
FROM members
WHERE secure_id_1  = T OR secure_id_2   = T OR secure_id_3 = T OR secure_id_4 = T OR secure_id_5 = T OR secure_id_6 = T OR secure_id_7 = T OR secure_id_8 = T OR secure_id_9 = T OR secure_id_10 = T

The error is :

Missing Type For Variable: T

The T variable gets is content from "$_POST['sec']" which is a number which is input on a form which call the above query in another page.

If I construct the query like:

SELECT *
FROM amember_baggagemembers
WHERE secure_id_1  = T 

it work fine, but I need to test the content for all the "secure_id_*" fields.

Can anyone see what is wrong or where I am screwing up.

[laserlight]

hmm... shouldn't it be $T instead of T?

You might be able to simplify it to:

SELECT *
FROM members
WHERE IN $T IN (secure_id_1, secure_id_2, secure_id_3, secure_id_4, secure_id_5, secure_id_6, secure_id_7, secure_id_8, secure_id_9, secure_id_10)

Though having another table to store secure_id would be better from a normalisation point of view.

[dcjones]

Hi Laserlight,

Once again to the rescue, it work with your simplified version.

many thanks