drop down box problem

[gnawz]

Hi.
I have a dynamic drop down that reads fields from the database.

I want a page to be opened in a new tab/window (target = _blank) when a user clicks on an item in the drop down.

How do I achieve that in PHP+Javascript?

My drop down

<select name = "sltStation">
   <option value="0">Select Station</option>
   <?
   $sql = "SELECT * FROM stations ORDER BY Name ASC";
         $result = dbQuery($sql);   
      if(dbNumRows($result))
      {
         while($row = dbFetchAssoc($result))
         {
            echo "<option>$row[Name]</option>";
         }
      }
      else
            {
            echo "<option>No Stations present</option>";
            }
    ?>

the data base consists 3 fields:
id, Name and Link (a hyperlink)

I want to display the Name in the drop down and require that when a user selects a name (onChange), it opens the associated link in a new page-meaning control stays at the current page

ie Click on name, open associated link

I hope I'm clear

Will appreciate yur help

[prabirchoudhury]

drop down box with auto form handler

=====Form Handler javascript===== ========

<script language="javas cript">
<!-- Begin
function formHandler(for m) {
var windowpropertie s = "height=450,wid th=500,location =no,"
+ "scrollbars=no, menubars=no,too lbars=no,resiza ble=yes";

var PopupUrl = form.site.optio ns[form.site.selec tedIndex].value;

popup = window.open(Pop upUrl,"Menupopu p",windowproper ties);

}

// End -->

</script>

============= Php html dropdown ===============

<?php
$sql = "SELECT p.* ";
$sql .= " FROM Person p ";

$csr = mysql_query($sq l);
?>
<form name=form>
<select name=site SIZE=1 onchange="formH andler(this.for m)">

<option value="0">Selec t Station</option>

<?
while ($row=mysql_fet ch_array($csr)) {
?>
<option value="Person/person_edit.php ?id=<? echo $row[personID]; ?>">
<? echo $row[personID]; ?>
</option>
<?
}
?>
</select>
</form>

Hope that gonna wrk


my blog
prabirinfo@gmai l.com

[gnawz]

Thanks a big bunch...

I changed it and used it pretty well