WHERE question

[aliento]

Hi,

I have two queries which i want to take them both .

$sql = "SELECT `id` FROM `ads` WHERE `state_id` = '$state_id' ; SELECT `id` FROM `ads` WHERE `state_id` = '$state_id' AND `category_id` = '$category_id';"

I want to make them both in one query but i have lack of knowledge .

 

[cags]

I don't understand your objective. The second query appears to be exactly the same as the first query only being more specific (the category_id must match as well as the state_id), since the first query will return all values from a specific state and the second query also requires values from the same state, the second query will only ever return rows that have already been found by the first, thus making it seem a little redundant.

[aliento]

my mistake , i was a little cloudy but you helped me think clearer. I found the solution.