PHPRunner 6.1 manual - Add dropdown list box with values for search

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?ctlSearchFor=".$data["company"].

"&srchOptShowStatus=1&ctrlTypeComboStatus=0&srchWinShowStatus=0&a=".

"integrated&id=1&criteria=and&type1=&value11=".$data["company"].

"&field1=company&option1=Contains&not1=a=search&value=1\">".

$data["company"]."</option>";

$str.="</select>";

echo $str;