Populating a combo box with a MySQL table's column

lukeurtnowski

I am trying to populate a combo box with a certain row of one of my sql tables, the name of the table is Category and the name of the row is CatNamee (Here iis some code...
<?php
$sql="SELECT CatName FROM Category WHERE FieldID=2";
$query=mysql_query($sql);
$result=mysql_fetch_array($query);
?>
<SELECT Name="Choice" SIZE="1" >
<?php
do {
printf("<option value="'.$result['CVTitle']'">.$result['CVTitle']"</option>");
}
while ($result = mysql_fetch_array($query));
?>
</SELECT>
Anyway... what Im trying to do is populate the combo box and when a specific CatName is selected from it, you will be taken to a page for that category

iongion

you can populate it like that , but the trigger must be written in javascript or a client side scripting language , and that trigger must be built regarding your readings from the database.

so .. let's make it clear :

populate the combo from a database , and make the onChange handler respond to your , let's say "la_schimbare" function, so in your tag that defines the combo you put onChange="la_schimbare()" (with as many parameters as u want) , but before using this function you must declare it , so , above the code that defines and populates the combo (including pure html code) , you make a <javascript....></javascript> construction and between this tags you put :
function la_schimabre()
{
perform action for : document.bla.blaa.blaaa.yourComboName.value;
}

lukeurtnowski

When you say trigger, do you mean the link to the page, I will give that a whirl and let you know of the outcome, thanks for your quick reply

lukeurtnowski

Here is the code I came up with for the function (Category())
which I use on the <select> 's onchange event.

function Category(){
open("Category.php?Title=document.Choice.value","Window1","toolbar=no");
}
Is this right, it seems very smple?
Im trying to link all the combo boxes values to a template (php)page with a variable included in it. thanks

iongion

yes it is like that , but be careful , that different browsers have different javascript DOM implementation so u must take care by writing a script that will detect the browser first , then in an if ... else if ... u will put all DOM functions that u want to call , for every browser.