|
Add dropdown list box with values for search. E.g. when you
select a company name from dropdown list box, only the data
concerning selected company are displayed.
To add this event use 
(Insert PHP code
snippet) button on the Visual Editor page.
 Note: Change the values listed in
red to match your specific needs.
//create dropdown box
$str = "";
$str.= "<select onchange=\"window.location.href=this.options[this.selectedIndex].
value;\"><option value=\"\">Please select</option>";
//select values from database
global $conn;
$strSQL = "select company from tablename";
$rs = db_query($strSQL,$conn);
while ($data = db_fetch_array($rs))
$str.="<option value=\"tablename_list.php?a=search&value=1&SearchFor=".$data["company"].
"&SearchOption=Contains&SearchField=company\">".$data["company"]."</option>";
$str.="</select>";
echo $str;
|
|
