MySQL-Export from wp_s2member_custom_fields

Hi @ all,

I just tried to export some usermeta from the WP “wp_s2member_custom_fields” – Database. I have 900 users – some of them have Quotes and Double-quotes in their custom fields. The DB looks all right and has all serialized Data WITH all Quotes in it.
But when I try to export my userlist with its custom fields, only users without quotes are displayed? I tried the “unserialize” command but that didn’t work.

Could someone help me, because I’ve tried nearly everything but nothing works. Google drops nothing useful :(

Here’s my code:

$query = "SELECT meta_value FROM wp_usermeta WHERE meta_key = 'wp_s2member_custom_fields'";
$result = mysql_query($query)
or die("ERROR connecting DB");

while ($line = mysql_fetch_assoc($result)) 
{ 
    $pickthis = $line[meta_value];
    $showme = unserialize(utf8_encode($pickthis));

    echo utf8_decode($showme['vita']);
}

Thans a lot for helping me out!!!The Field “vita” is a text-area!!

Greets

Ok, i’ve managed to use “string replace” to display quotes! Now I have another Problem:
Users, who paste WORD-formated Text into the Input-Fields, create DB-Errors!! How can I solve this? Is there a solution to replace the „“ with the “normal” ones like ” ”

Any ideas?
PLEASE HELP!