Querying: 2 tables

[localhost]

Hello
i have 2 tables:

questions:[id],[question],[setid]

sets:[id][catid]

where

questions.setid = sets.id

now i would like to select all questions from the questions table
that belong to a set (sets table)where catid=1

so i do

SELECT question
FROM questions,sets
WHERE questions.setid=sets.id
AND sets.catid=1

but it doesnt seem to work
maybe i'm doing wrong something in the script but
do you think the query is wrong??

thanks!

[stolzyboy]

are you receiving any errors?

[stolzyboy]

ok, try this

select questions.question,questions.setid, sets.catid, sets.id from questions, sets where questions.setid = sets.id and sets.catid = 1

[localhost]

no i do not recieve any errors
it doesnt limit the select to catid=1

to be more specific:

the compete query is:

$query=mysql_query("
SELECT question 
FROM questions,sets 
WHERE questions.setid=sets.id 
AND sets.catid='1' 
 $str");

$str is a string that come from users input

if users input = bla1 bla2

$str="AND questions.question LIKE '%bla1%' OR questions.question LIKE '%bla2%' ";

if the variable $str contains 1 word everything is ok
else the query doesnt work
??

:rolleyes:

[localhost]

i tryied what you suggeste but it doesn work

i think the query is ok

maybe i should search the bug elsewhere in my script
thanks anyway!