Thank you so much.
It worked now.
But I am now thnking if :
Is it possible to store the links that the user is being redirected to in the database. so now if Options are stored in one column in the database and the values of the option (where the user should be directed to)are stored in another column, then why doesnt it work? (The value of the selected option will change depending on the option.)
Code:
<html>
<head>
<!--
<script language="JavaScript">
function go ( ){
window.location=document.myteam.myteam1.options[document.myteam.myteam1.selectedIndex].value "
}
</script>
-->
</head>
<title>Homepage</title>
<?php
//dbconnect is a file which has the connection paramaters
//to the server and the database.
require ("dbconnect.php");
$sqlquery="SELECT teamqueuename FROM teamqueue;";
$results= mssql_query($sqlquery);
?>
<body>
<table>
<tr><td><center>Welcome to the homepage!</center><td></tr>
<tr><td><br></td></tr>
<tr><td>Please select a team queue</td></tr>
<form name="myteam" method="GET" target="_blank">
<tr><td><select name="myteam1" onChange="go()">
<?php
while ($row=mssql_fetch_array($results)){
$teamqueuename=$row["teamqueuename"];
$url=$row[“url”];
echo "<option value= ‘$url’>$teamqueuename</option>";
}
mssql_close($sqlconnect);
?>
</select></td></tr>
<tr><td><input type="submit" value="submit"></td></tr>
</form>
$url=$_GET['$url'];
</table>
</body>
</html>
Thank you..