I'm new to PHP and I'm confused on how to call queries. In Coldfusion, I can write a query to find distinct cities in the db for example. Then, later in the program I can call the query using
<cfoutput query = "name">
<option>#city#</option>
This will loop through putting every distinct city that was found as an option. How can I accomplish this in PHP?