This topic is locked
[SOLVED]

 Need help: "Add dropdown list box with value SHOW AL

2/9/2010 7:13:34 AM
PHPRunner General questions
V
vlad1211 author

Hi folks,

In PHPRunner 5.1 manual I have found a sample of "Add dropdown list box" code.

http://xlinesoft.com/phprunner/docs/add_dropdown_list_box_with_values_for_search.htm
//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;
For a such newbi as me me it works perfect, but I need to add into the code one more option/value "Show All" (which should work as a button "Show all" does). If someone khows how to solve the problem it would be greatly appreciated!

Best regards,

Vlad

Admin 2/9/2010

Vlad,
try this.

//create dropdown box

$str = "";

$str.= "<select onchange=\"window.location.href=this.options[this.selectedIndex].

value;\"><option value=\"\">Please select</option>";
$str.="<option value='tablename_list.php?a=showall'>Show all</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;
V
vlad1211 author 2/9/2010

Thank you very much!!!! Yes, it works now.. Большущее спасибо!!!