Php/mysql Combo Box

[Tony 0]

Salam... Hamba ada satu combo box.. mcm kat bwh:

##############

Most common web script?

- Select One - <- browser akan paparkan yg ini dulu sblum pengguna membuat pilihan.

1- PHP

2- ASP.NET

3- JSP

4- Rails

##############

kemudian hamba nk dia paparkan ASP.NET dulu sebagai pilihan utama bila field Most common web script? dalam MySQL papar sebagai ASP.NET:

##############

Most common web script?

- Select One -

- PHP

- ASP.NET <- browser akan paparkan yg ini pulak bila field kat DB==ASP.NET. Tapi dlm masa yg sama pilihan2 lain tetap dipaparkan

- JSP

- Rails

##############

kengkawan ade idea? terima kasih

Edited September 11, 2008 by Tony

[ejoe 0]

cth yg biasa aku buat....aku tak tau table ko camne so aku just paste code maybe sebagai rujukan

<select name=state>

<?php
$results = mysql_query ("SELECT * FROM state ORDER BY state_name ");
if ($row = mysql_fetch_array($results))
{
do{
    $state_id2 = $row[state_id];
    $state_name2 = $row[state_name];
    if ($_GET[state_id2]==$state_id2)
    echo "<OPTION value=$state_id2 selected>$state_name2</option>";
    else
    echo "<OPTION value=$state_id2>$state_name2</option>";
  }
  while($row = mysql_fetch_array($results));
}
?>
</select>

[Shahrizan Noor 0]

Pastikan tambah keyword selected pada drop down berikut.

<select name="bahasa">

<option value="PHP">PHP</option>
<option [b]selected[/b] value="ASP.NET">ASP.NET</option>
<option value= ...
...
</option>

</select>

so kalau u call the list dalam query, algorithm dia seperti berikut:

if name == "ASP.NET" then
   output "<option selected ...> name </option>"
else
   output "<option> name </option>
end if

Edited September 12, 2008 by Shahrizan Noor

[DrASAG 0]

A'kum. ejoe itu kalo senarai nama state dlm database kan? kalo senarai tu tak letak dlm database caner lak. cth kalo aku buat

<option>Information Technology</option>
<option>Accounting</option>
<option>Financial</option>

pastu masa masuk rekod, user pilih Financial, then hanya nilai Financial yg disimpan. So bila user nak edit, mcm mana nak paparkan nilai Financial as selected value, dlm masa yg sama option yg lain tu ada jgk. apa yg aku buat...

<option>Information Technology</option>
<option>Accounting</option>
<option>Financial</option>
<option selected><?php echo $myrow['Category'] ?></option>

mmg jadik, dia akan select Financial tu, and senarai lagik 2 tu pon ada jgk. but, nampak cacat sket bila user klik drop down tu, ada 2 nilai Financial dalam tu. mcm mana eik.... mesti ada cara lain kan....

[ejoe 0]

sebab tu better masukkan semua dlm database...

kalo tak guna database ko kena buat 1-1 ygmane tak sistematik

if ($myrow['Category']=="Finacial")
{

    echo "<option>Information Technology</option>";
    echo "<option>Accounting</option>";
    echo "<option selected>Financial</option>";
}

elseif ($myrow['Category']=="Information Technology")
{

    echo "<option selected>Information Technology</option>";
    echo "<option>Accounting</option>";
    echo "<option>Financial</option>";
}
.............
.............

[DrASAG 0]

ooo gitu ker.... thanx....

[Tony 0]

Terima kasih mr.ejoe dan mr.Shahrizan Noor.... hamba x noticed syntax "selected" ... thanks again! noble prize for both of you