& lt?服務器端編程語言(Professional Hypertext Preprocessor的縮寫)
$ sql = ' select * from city
$ RES = MySQL _ query($ SQL);
$ cities = array();
while($ row = MySQL _ fetch _ assoc($ RES))
{
$ cities[$ row[' id ']]= $ row[' name '];
}
& gt
& ltselect name = " pub form[city]" class = " SG select scate " id = " city " >
& ltoption selected = " selected " value = " " & gt;請選擇壹個城市
& lt?PHP foreach($ cities as $ id = & gt;$city ) {?& gt
& lt選項值= " & lt?php echo $ id?>& gt& lt?php echo $ city?& gt& lt/option & gt;
& lt/select & gt;
原理是從mysql中查詢所有城市的數據並做成壹個$cities的數組,然後循環$cities,按照下拉表單的格式輸出option選項。