insert two inputs into same cell mysql

[MDanz]

in mysql i have the field keywords..

 

i have two inputs...

 

textfield and a dropdown menu

 

both named 'keywords'

 

when i insert it only takes dropdown menu.. figuring because its second

 

how do i insert both into mysql in the same cell

 

e.g.

 

textfield says hello

 

select name says david

 

insert into mysql field keywords cell..

 

it should say hello david.

[ozestretch]

Well 2 options I guess.

 

[*]Change one input to a different name, then insert both values into the field required

<input type="text" name="keywordtext" /><select name="keywordselect"><option>David</option></select>

INSERT INTO `mytable` (keywords) VALUES ($_POST['keywordtext']."".$_POST['keywordselect']);

[*]Create an array from keywords like

<input type="text" name="keywords[]" /><select name="keywords[]"><option>David</option></select>

INSERT INTO `mytable` (keywords) VALUES ($_POST['keywords'][0]."".$_POST['keywords'][1]);

[RussellReal]

serialize, put into db, when you're fetching unserialize, and use its quite easy