01.
<label
class
=
"control-label col-lg-2"
align=
"right"
>คำนำหน้า : </label>
02.
<div
class
=
"col-lg-2"
>
03.
<select
class
=
"form-control"
id=
"pName"
name=
"pName"
required>
04.
<option value=
""
>~~เลือกคำนำหน้า~~</option>
05.
<?php
06.
$sql
=
"SELECT name FROM pname order by name"
;
07.
$result
=
$conn
->query(
$sql
);
08.
while
(
$row
=
$result
->fetch_object()) {
09.
echo
"<option value='"
.
$row
->name.
"'>"
.
$row
->name.
"</option>"
;
10.
}
11.
?>
12.
</select>