468,249 Members | 1,594 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,249 developers. It's quick & easy.

PLEASE HELP - How to add URL to options in drop down list

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.

Aug 14 '06 #1
3 4161

cp**********@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 <optiontag, 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.

Aug 14 '06 #2
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 :)
cp**********@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.
Aug 14 '06 #3
"Robert" <ro*******@gmail.comwrote in news:1155543441.183922.320090
@m79g2000cwm.googlegroups.com:

cp**********@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.

:: top posting fixed ::
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 :)

Why use the above method? It not only relies on javascript to work, but
also opens a new window. You may as well add an alertbox telling the
user you hate them.

--
Karl Groves
www.karlcore.com
Aug 14 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Adam Smith | last post: by
2 posts views Thread by Martin Schmid | last post: by
4 posts views Thread by teknoshock | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.