search by VALUE from table field function

Hi,
the best way to add your own custom dropdown with values from another table is custom event (Insert PHP code snippet option on the Visual Editor tab).

Here is a sample:

global $conn;

$value = "<select onchange=\"window.location.href='Mytable_list.php?a=search&value=1&SearchOption=Contains&SearchField=FieldName&SearchFor='+this.options[this.selectedIndex].value;\">";

$str = "SELECT SomeValue FROM Mytable where Placeno='Nije placeno' ORDER BY SomeValue ASC;

$rs = db_query($str,$conn);

while ($data = db_fetch_array($rs))

$value.="<option value=\"".$data["SomeValue"]."\">".$data["SomeValue"]."</option>";
$value.="</select>";

echo $value;