Which is the better way to introduce an array inside a mysql database?
I generate an array with a list of e-mail adresses I have just send and I want to keep this list any time I send a mailing to keep records of who did I sent them. I want to introduce this e-mail list in a database column call emailed.
Which is the best way, if we consideer the posibility I may like to recover the list easily and make it an array again to resend mails again??
Introduce array in database
Moderator: General Moderators
I didn't explained myself quite well, mates!
I'm sorry.
I have a variable called $unidad which is an array composed by the list of e-mails of the people I have sent an e-mail, I also have a column with name "e-mailed" in which I would like to store this array.
I think the question is:
How to convert the array into a string to be stored in the database and easily converted again in an array again if needed?
The array is a simple one, just e-mails:
1@hotmail.com, 2@hotmail.com, 3@hotmail.com....
I'm sorry.
I have a variable called $unidad which is an array composed by the list of e-mails of the people I have sent an e-mail, I also have a column with name "e-mailed" in which I would like to store this array.
I think the question is:
How to convert the array into a string to be stored in the database and easily converted again in an array again if needed?
The array is a simple one, just e-mails:
1@hotmail.com, 2@hotmail.com, 3@hotmail.com....
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
typically, no. What if you want to know the emails you've sent to x,y,z addresses? How easy will it be to construct a query that's simple and works well with it?
If you read this, you may understand why we suggest the things we do.
If you read this, you may understand why we suggest the things we do.