That worked for me. Thanks very much for replying.

Cheers,

Ciaran

AND num NOT IN ('$ExcludeItems')

But it doesn't work for me. For some reason it is only excluding the first in the list. Can anyone shed some light? Below is the full call.

list($productsRecords, $productsMetaData) = getRecords(array(
'tableName'   => 'products',
'where'       => "product_location = '$CurrentLocation' AND product_category like '%$CurrentCID%' AND num NOT IN ('$ExcludeItems')",
'orderBy' => "title ASC",
'loadUploads' => true,
'allowSearch' => false,
))

Cheers,
Ciaran

Each item has a list of categories to chose which could be multiple ( Field name = video_category). I am passing this variable in the URL, so if the variable is 2, then I want every item with 2 selected for the field name 'video_category' to appear.

I can do it if I put the value in manually e.g. below:

// load records from 'videos'
list($videosRecords, $videosMetaData) = getRecords(array(
'tableName' => 'videos',
'where' => ' video_category LIKE "%\t2\t%" ', // contains 4
'loadUploads' => true,
'allowSearch' => false,
));

but I don't know what to do to pull the variable and put it in the query. 

I am wondering is it possible to create several different decision trees using the builder? I am looking for a solution that will allow me to add as many decision trees as possible.

I will have a home page which will show all the possible initial decisions trees that has been created. But once the user selects the button they go into the questions assigned to the decision tree.

Example:

This chooses the best pet for you. Do you want a male or female pet?

(select = Male, Female)

(user chooses female)

Female pets are chosen on hair color. What color is your hair?

(select = Red, Blonde, Brunette, White, Other)

(user chooses White)

White pets come in 4 sizes. Which size would you prefer?

(select = Tiny, Small, Medium, Large)

...and so on based on their choices...

... If they had chosen male for their first answer, then instead of the hair color question the following would appear:

Male pets are based on height. How tall are you?

(select = Under 4ft, 4ft-5ft, 5ft-6ft, Over 6ft)

(User chooses over 6ft)

Wow, you are tall. Because you are so tall a hamster would be perfect for you.

(no choices as this ends this path.)