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