Dropdown Data from Table ( PHP script)

()
(if ($edit==1)
{
$perintah="SELECT * from tm_jabatan where kd_jabatan='$kd_jabatan' and stat_jab='1' order by kd_jabatan";
$hasil=mysql_query($perintah);
while ($row=mysql_fetch_array($hasil))
{
$kd_jabatan=$row["kd_jabatan"];
$nm_jabatan=$row["nm_jabatan"];
echo("$kd_jabatan | $nm_jabatan");
}
}

$perintah="SELECT * from tm_jabatan where stat_jab='1' order by kd_jabatan";
$hasil=mysql_query($perintah);
while ($row=mysql_fetch_array($hasil))
{
$kd_jabatan=$row["kd_jabatan"];
$nm_jabatan=$row["nm_jabatan"];
echo("$kd_jabatan | $nm_jabatan");
}
(?>)

()

Sintax :

select.....
php quote

if ($edit==1)
{
$perintah="SELECT * from tm_jabatan where kd_jabatan='$kd_jabatan';
$hasil=mysql_query($perintah);
while ($row=mysql_fetch_array($hasil))
{
$kd_jabatan=$row["kd_jabatan"];
$nm_jabatan=$row["nm_jabatan"];
echo(" selected>$kd_jabatan|nm_jabatan");
}
}

$perintah="SELECT * from tm_jabatan where stat_jab='1' order by kd_jabatan";
$hasil=mysql_query($perintah);
while ($row=mysql_fetch_array($hasil))
{
$kd_jabatan=$row["kd_jabatan"];
$nm_jabatan=$row["nm_jabatan"];
echo("$kd_jabatan | $nm_jabatan");
}

php quote

end select