01.
<html>
02.
<head>
03.
<title>ThaiCreate.Com Tutorial</title>
04.
</head>
05.
<?php
06.
$strDefault
=
"C003"
;
07.
mysql_connect(
"localhost"
,
"root"
,
"root"
)
or
die
(mysql_error());
08.
mysql_select_db(
"mydatabase"
);
09.
?>
10.
<body>
11.
<form action=
"phpLlistmenuDatebase2.php"
method=
"post"
name=
"form1"
>
12.
List Menu<br>
13.
<select name=
"lmName1"
>
14.
<option value=
""
><-- Please Select Item --></option>
15.
<?php
16.
$strSQL
=
"SELECT * FROM customer ORDER BY CustomerID ASC"
;
17.
$objQuery
= mysql_query(
$strSQL
);
18.
while
(
$objResuut
= mysql_fetch_array(
$objQuery
))
19.
{
20.
if
(
$strDefault
==
$objResuut
[
"CustomerID"
])
21.
{
22.
$sel
=
"selected"
;
23.
}
24.
else
25.
{
26.
$sel
=
""
;
27.
}
28.
?>
29.
<option value=
"<?php echo $objResuut["
CustomerID
"];?>"
<?php
echo
$sel
;?>><?php
echo
$objResuut
[
"CustomerID"
].
" - "
.
$objResuut
[
"Name"
];?></option>
30.
<?php
31.
}
32.
?>
33.
</select>
34.
<input name=
"btnSubmit"
type=
"submit"
value=
"Submit"
>
35.
</form>
36.
</body>
37.
</html>
38.
<?php
39.
mysql_close();
40.
?>