This should be a snap, whats wrong with me?

[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.

[diego25]

You're mixing double and single quotes all over the place! Try:

<?php 
$sql="SELECT CatName FROM Category WHERE FieldID=2"; 
$query=mysql_query($sql); 
$result=mysql_fetch_array($query); 
?> 
<SELECT Name="Choice" SIZE="1" > 
<?php 
while ($result = mysql_fetch_array($query)) { 
printf('<option value="'.$result['CVTitle'] . '">'.$result['CVTitle'] . '</option>'); 
} 
?> 
</SELECT> 

Diego

[lukeurtnowski]

Thanks,m do you happen to know how to make the item in the combo box (once it is selected) link to a certain .php page with a certain variable brought over from the combo box? Something like this, <a href="(whatever.php?CatName=(ComboBox.value)">

[diego25]

Specify the form's action to whatever.php, then name your combo box CatName, and your option values would be ...your values...

Diego