- <?php
- $link = mysql_connect('localhost','root','pwd');
- mysql_select_db('db');
- $sql = "select region_id,local_name from regions where region_grade=1";
- $result = mysql_query($sql);
- $i =0;
- while ($row= mysql_fetch_assoc($result)) {
- $list[$i]['text']=$row['local_name'];
- $list[$i]['value']=$row['region_id'];
- $i++; //Vevb.com
- }
- $list = json_encode($list);
- echo $list;
- ?>
新闻热点
疑难解答