1 Vote Vote

Storing multiple dynamic values within one field in mysql.

Posted by topdog 284 days ago Questions| values mysql dynamic values All

How can i go about storing multiple values ( numbers and words ) within one field of a mysql database and then extracting them again as and when i need them using mySQL and php?

for example: I want to store the dynamic values a user will enter using a form for example 1, 2, foo, tree, and monkey all in the same field in a database.

then i want to extract it and put them on seperate lines for example: 1 2 foo tree monkey

any ideas?

Discuss Bury


Who Voted for this Question