01.<?php
02.error_reporting(E_ALL ^ E_NOTICE);
03. $host = "localhost";
04. $user = "root";
05. $passwd = "root";
06. $db = "ajaxdemo";
07.
08. $connect = mysql_connect($host,$user,$passwd) ;
09.
10. mysql_select_db($db);
11. mysql_query('SET NAMES utf8');
12.
13. $sql = "SELECT job FROM user ORDER BY id, job";
14. $result = mysql_query($sql) or die(mysql_error());
15. $prev='';
16. while ($row = mysql_fetch_array($result)) {
17. if ($prev != $row['FirstName']) {
18. if ($prev) {
19. echo "<optgroup>";
20. echo "<optgroup label='--------------'>";
21. $prev = $row['id'];
22. }
23. }
24. echo "<option value='".$row['id']."'>".$row['job']."</option>";
25. echo "</optgroup>";
26. }
27.?>
