Populate Combo from Database and Dynamic Link

[34534534534555]

Hello,

Is it possible to populate a combo box from a column in a mySQL database? then run a query based on the item selected?

Also when the end results are returned, which will be a list of items, i want to create a link to .php page for each item, so that i can manipulate it,.

Thanks in Advance


| Feedback is always appreciated as this will help to further our knowledge as well |

 

[sleipnir214]

Yes, all that is possible.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[34534534534555]

could you please point me in the right direction for some code, or better a tutorial on doing this? I have searched google and not come up with anything for my first request.

I had something on the second one , but i have lost it.

Thanks


| Feedback is always appreciated as this will help to further our knowledge as well |

 

[sleipnir214]

The PHP online manual is a good place. It contains copious example code.

For fetching from MySQL, take a look here:

http://us3.php.net/manual/en/function.mysql-fetch-assoc.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[hos2]

if you specify what you mean with combo, a select list or an checkbox ???

here is an example of a select list

$query="SELECT botid,botdescr FROM bottlertable ORDER BY botdescr";
$rsbot=mysql_query($query,$conn);

<TR><TD><P>Bottler</P></TD><TD><select name=&quot;whbotid&quot;><option value=&quot;&quot;>Empty
<? 
$i=0;
$list = mysql_num_rows($rsbot); 
while($i < $list)	{
$row = mysql_fetch_array($rsbot); 
$botid=$row[&quot;botid&quot;];
$botdescr=$row[&quot;botdescr&quot;];

   echo &quot;<option value='$botid'>$botdescr&quot;;
$i++;
}
?>

</select></TD><td></td></TR>

for the rest you can deping on what you selected use the submitted variable in a condition