MySQL Query - JOIN and WHERE

[vigour]

I'm using this query and it works perfect:

$result = mysql_query("SELECT DISTINCT place FROM archive JOIN place ON place.place_id=archive.place_id ORDER BY place");

But I'm trying to add that it should only select posts with a certain ID.

I have places with IDs and municipalities with IDs.
What I want to do is to select places only from a certain municipality.

Can I add WHERE to my query?

I would like to add this:
WHERE municipality = '$municipality_id'

But I can't get it to work...

Help please, thanks in advance!

[psuplat]

How is the municipality stored in the table, what datatype?
If they are numerics the query won't work cause you're trying to pass string in place of numeric

WHERE municipality = '$municipality_id'
it should be
WHERE municipality = $municipality_id

[Res]

What error is mysql giving you? Or is it saying empty result?

Stab in the dark, do both tables have the field municipality? If so you will have to qualify the field with a table.

place.municipality = $id
//versus
municipality = $id

Mysql can sort out the single quotes for an integer field. Once upon a time it caused indexes to be ignored, but no longer the case.