[SOLVED] Inputting and Selecting Multiple Values in 1 column of 1 field in MySQL

[MasterACE14]

Evening,

 

I would like to know, how to input multiple values into a single column of a MySQL field,

example:

fields:

id  -  username  -  hobbies

 

and input multiple values into hobbies, like so:

id  -  username  -  hobbies

2      MasterACE      fishing, juggling, model making

 

How would I be able to input multiple values in the hobby column.

And then how do I Select a certain value in the hobbies column, say juggling for example, how could I select that?

 

Regards ACE

[jagat21]

For selecting multiple values for hobbies field u can use checkboxes. And @ the time of inserting record combine them in a single string. and store the value.

[MasterACE14]

I know I can select it using a check box, but the mysql_query, would normally be like this:

mysql_query("SELECT `hobbies` FROM `users`");

 

how do i do the same query, but selecting individual values within hobbies?

 

Regards ACE

[jagat21]

After firing the select query u have written,

 

"select hobbies from tablename ",

 

u can use explode() function in order to get the individual values of each hobbies.

 

i.e. u have stored following values of hobbies in database table :

 

id ..... hobbies

1...... reading, music, cricket

 

now after selecting this record from query,

 

$hobbies = explode(',',$row['hobbies']);

 

this will give u an array of all hobbies that u have stored in single field. so u can access individual hobbies as an array elements.

[MasterACE14]

Excellant! Thanks man, much appreciated