Posted by Robert on 12/15/41 11:55

Try using this:

$sql_query = mysql_query("SELECT DISTINCT year, semester, school,
schoolurl FROM schoolproject_pics ORDER BY year");
echo "<select name=\"semester\">";
while(list($year, $semester, $school, $schoolurl) =
mysql_fetch_array($sql_query))
{
echo "<option value=\"$year\"
onclick=\"window.open('$schoolurl');\">$school ($year
$semester)</option>";
}

Hope it helps.. You cannot have an href inside of an option display.
But you can use some nifty JS to help you out :)
cpptutor2000@yahoo.com wrote:
> Could some PHP guru please help me? I am have a drop down list, whose
> options are read in dynamically from a table in a MySQL database. one
> of the items being read in is an URL. I am
> unable to display this URL in the drop down list. The following is the
> code snippet I am using:
>
> $sql_query = mysql_query("SELECT DISTINCT year, semester, school,
> schoolurl FROM
> schoolproject_pics ORDER BY
> year");
> echo "<select name=\"semester\">";
> while(list($year, $semester, $school, $schoolurl) =
> mysql_fetch_array($sql_query)){
> echo "<option value=\"$year\">$year $semester <a
> href=\"$schoolurl\">$school</a></option>";
> }
>
> When the drop down list is displayed, I do not see the URL. Could
> someone please point out what exactly I am doing wrong? Thanks in
> advance for your help, any help would be greatly appreciated.

[Back to original message]