This topic is locked

drop down box

12/16/2008 4:18:08 AM
PHPRunner General questions
F
futo author

hello,
i have next code ("Search by City"):
//select values from database

global $conn,$smarty;

$rowsearch=array();

$rstt = db_query("SELECT Unos_podataka.Poslovnica, Count(Unos_podataka.Poslovnica) AS CountOfPoslovnica FROM Unos_podataka GROUP BY Unos_podataka.Poslovnica", $conn);

$ind=0;

while($data=db_fetch_array($rstt))

{

$rows=array();

$PoslovnicaName = str_Replace(" ","+",$data["Poslovnica"]);

$rows["href"]="Unos_podataka_list.php?a=search&value=1&SearchFor=".$PoslovnicaName."&SearchOption=Contains&SearchField=Poslovnica";

$rows["1Poslovnica_value"]=$data["Poslovnica"]." (".$data["CountOfPoslovnica"].")
";

$rowsearch="<a href=\"".$rows["href"]."\">".$rows["1Poslovnica_value"]."</a>";

echo $rowsearch;

}
-----------------------------------------------------------------------------------------------------------

Unos_podataka = TABLE NAME

Poslovnica = COLUMN NAME
I WANT TO DISPLAY THIS LIKE DROPDOWN MENU NOT LIKE LINKS
ANY HELP PLEASE,
THANKS

J
Jane 12/16/2008

Hi,
here is just a sample:

//select values from database

global $conn,$smarty;

$rstt = db_query("SELECT Unos_podataka.Poslovnica, Count(Unos_podataka.Poslovnica) AS CountOfPoslovnica FROM Unos_podataka GROUP BY Unos_podataka.Poslovnica", $conn);

$ind=0;

$rowsearch = "";

$rowsearch.= "<select onchange=\"window.location.href=this.options[this.selectedIndex].value;\">";

while($data=db_fetch_array($rstt))

{

$rows=array();

$PoslovnicaName = str_Replace(" ","+",$data["Poslovnica"]);

$href="Unos_podataka_list.php?a=search&value=1&SearchFor=".$PoslovnicaName."&SearchOption=Contains&SearchField=Poslovnica";

$value=$data["Poslovnica"]." (".$data["CountOfPoslovnica"].")";

$rowsearch.="<option value=\"".$href."\">".$value."</option>";

}

$rowsearch.="</select>";

echo $rowsearch;