Mysql column populating drop down menu issue

[Philth]

Hi there,

I've essentially got a form with several drop down, each populated by columns in various tables.

The populating bit works fine - the column rows appear as they should in the menu.

Ideally the user needs to make their selections, and enter the form into a new database table.

The problem is, when the selection is entered into the new table, only the first word of the string is entered. For example, the drop down may have...

"Category One"
"Category Two"
"Category Three"

When the form is submitted only the word "Category" is entered into the database.

Here is the code, it takes the column 'courseTitle' from one table, displays it in a menu, and then saves the selection into a new table as 'eventName'.

<?
include("connect.php"); 
$query="SELECT courseTitle FROM course";
$result = mysql_query ($query);
echo "<select name='eventName'=''></option>";
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[courseTitle]>$nt[courseTitle]</option>";
}
echo "</select>";// Closing of list box 
?>
 

Apologies if I've made it slightly long winded.

[Markus]

@Dormilich
Yeah, what Dorm said. ;)

[Philth]

Yeah, sorry for being dim today.

Thanks for everyones help.

[Dormilich]

and while we're quoting........ . you should always quote the array's keys (unless they're variables or indeed constants (which is btw rather rare))

[dlite922]

@Philth
Me too, I knew it has something to do with the values not posting correctly, thus form issue.

I always quote my html attributes. It's best to always ensure they're valid also:

http://validator.w3.org/

preferably with XHTML 1.0

Cheers,



Dan

[Dormilich]

@dlite922
sadly, there is no XHTML support in IE.......