|
|
Posted by cpptutor2000 on 10/20/14 11:55
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.
Navigation:
[Reply to this message]
|