Drop Down Menu

[traydavid]

This code creates one drop down menu for each item in the table. I’d like all the items in the table to be in one drop down menu. Seems like something simple in the html, but I can’t figure it out. Any help is appreciated. Thanks.

[php]<?php

$query = “SELECT typeid, foodtype from intlfoodtype”;
$result = mysql_query($query);

echo “<table class=“ex3” border=“0”>\n”;
while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
$typeid = $row[‘typeid’];
$foodtype = $row[‘foodtype’];

  echo "<tr><td width=\"100\">\n";
  echo "</td><td>\n";

  echo "<select>";
  echo '<option value="'.$typeid.'">'.$foodtype.'</option>';


  echo "</td><td>\n";
  echo "</td></tr>\n";

}
echo “”;
echo “\n”;

?>[/php]

[Topcoder]

Give this a try…

[php]<?php

$query = “SELECT typeid, foodtype from intlfoodtype”;
$result = mysql_query($query);

echo “<table class=“ex3” border=“0”>\n”;
echo “

<td width=“100”>\n”;
echo “\n”;
echo “”;

while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
$typeid = $row[‘typeid’];
$foodtype = $row[‘foodtype’];

  echo '<option value="'.$typeid.'">'.$foodtype.'</option>';

}

echo "</select>";
echo "</td><td>\n";
echo "</td></tr>\n";
echo "</tr></table>\n";

?>[/php]

[traydavid]

It worked! Thank you! I appreciate it.

[traydavid]

Give this a try…

[php]<?php

$query = “SELECT typeid, foodtype from intlfoodtype”;
$result = mysql_query($query);

echo “<table class=“ex3” border=“0”>\n”;
echo “

<td width=“100”>\n”;
echo “\n”;
echo “”;

while($row=mysql_fetch_array($result, MYSQL_ASSOC))
{
$typeid = $row[‘typeid’];
$foodtype = $row[‘foodtype’];

  echo '<option value="'.$typeid.'">'.$foodtype.'</option>';

}

echo "</select>";
echo "</td><td>\n";
echo "</td></tr>\n";
echo "</tr></table>\n";

?>[/php]

I tried to add a hyperlink and that blew it. Any idea how to repair that? Thanks in any event.

Here is the working PHP [php]echo ‘’.$name.’’;[/php]

And here is where I tried unsuccessfully to add the hyperlink: [php]echo “<option value=”’.$catid.’"><a href=“index.php?content=buyproducts&cat=$catid”>.$name.’’;[/php]

[Topcoder]

You can’t have an anchor tag inside a dropdown. :’(

However you can add an onClick even like this…

[php]google[/php]

Which will accomplish the same thing

[traydavid]

Thanks!

[traydavid]

Unfortunately this didn’t work either. I’m trying to loop through the catid numbers and link each one to the buyproducts page when selected from the dropdown. Thanks.

This does not work: [php]echo “<option onClick=”‘index.php?content=buyproducts&cat=$catid’">’.$name.’’;[/php]