[RESOLVED] How to seperate data serialized and input into MySQL

[callingrohit]

Hi everyone,

I have a form with checkbox input and the data is stored into a MYSQL table.

So I serialize this checkbox data before inserting it into the database. Now I also export the data with a

click of a button into a spreadsheet.

The data in the mysql table looks like this a:3:{i:0;s:3:"uno";i:1;s:3:"dos";i:2;s:4:"tres";}

I was wondering if its possible to modify the above data to just uno,dos,tres and then insert it into my excel table.

Thanks

cheers
rohit

[laserlight]

unserialize the data (or use it in its original form), and apply [man]implode/man on the array with a comma as the delimiter.

[callingrohit]

Thank you laserlight, your solution was perfect.

Very easy didn't think of implode.

thanks...

there was one more post but not sure where it disappeared, it was from bradgrafelman

I got an email with the solution of using foreach() statement.

Thank you all

Regards
Rohit

[bradgrafelman]

callingrohit wrote:

there was one more post but not sure where it disappeared, it was from bradgrafelman

Stupid instant notficiations... :p

Yeah, after I posted, I saw laserlight's post. Not only was it more informative, but I completely overlooked implode(). So, I sent my post hurtling into to the murky depths of cyberspace.

[callingrohit]

Thanks bradgrafelman