[MikaK]

I'm planning to show 1 event by memebrs at their public profile.

This should be the query:

PHP Code:

$query = "SELECT `eventid` , `userid` , `title` , `customfields` , `dateline_from`  
FROM `" . TABLE_PREFIX . "event`
WHERE userid = '$userinfo[userid]' 
ORDER BY `dateline_from` DESC
LIMIT 1"; 


In my case the customfields contains data regarding event type and location
like in the following example: a:2:{i:1;s:4:"Club";i:2;s:8:"Helsinki";}

What would be the best php code snippet for getting "Club" and "Helsinki" in displayed the final output?

Thanks for any insight.
-Mika