J
|
Jane 12/16/2008 |
Hi, //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; |