[Resolved] Multiple WHERE queries

[kerodeon]

What is the separator for multiple WHERE queries in a SELECT statement?

for example, i have:

$sql="SELECT * FROM ".$conf_db_prefix."posts WHERE pid=$loopcount";

but i also only want posts that have 'topicid=$var' so how would i only get that data?

[petitduc]

SELECT *
FROM table1
WHERE
pid=$loopcount
AND
topicid=$var
AND
.........
AND
.........

[kerodeon]

ohhh, ok cool, i was thinking that it was WHERE id=$bla & other=$other, like in php (get variables)

oh well, close, and thanx for the info.