Mysql列填充下拉菜单问题 [英] Mysql column populating drop down menu issue

问题描述

你好，


我本来有一个带有几个下拉的表单，每个表都填充了各种表中的列。


填充位工作正常 - 列行显示在菜单中。


理想情况下，用户需要进行选择，并将表单输入到新的数据库表中。


问题是，当选择输入新表时，只输入字符串的第一个单词。例如，下拉列表可能包含......


类别一

类别二

" ;第三类


当提交表格时，只提供类别一词。输入到数据库中。


这是代码，它从一个表中获取列''courseTitle''，在菜单中显示它，然后将选择保存到一个新的table为''eventName''。

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

展开 | 选择 | Wrap | 行号

推荐答案

我不是知道你为什么在这里有一个等号和额外的引号：

I don''t know why you have an equal sign and extra quotes here:

展开 | 选择 | Wrap | 行号

非常感谢Dan的回复，


我没有''注意额外的报价。他们没有任何区别。


插入SQL没什么特别的，我不能发现它有什么问题。

Many thanks for the reply Dan,

I didn''t notice the extra quotes. They made no difference either way.

The insert SQL is nothing special, I can''t spot anything wrong with it.

展开 | 选择 | < span class =codeLinkonclick =WordWrap（this）;> Wrap | 行号

echo

这篇关于Mysql列填充下拉菜单问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！