Posted by flamer die.spam@hotmail.com on 12/17/33 11:55

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.

you can't have <> tags inside of an <option> tag, you can either just
display the url inline, $year $semester $school, or you will need to
put it in the option value field and put $year elsewhere.

Flamer.

[Back to original message]