get image name from image field database in flexicontent

Hi,

I want to write a custom sql query to get image name from image field in database.How to get this value.

I wrote this query

$myquery = 'SELECT value FROM xrlwc_flexicontent_fields_item_relations WHERE field_id = 24 AND item_id = 4'

and I am getting result as

a:7:{s:12:"existingname";s:0:"";s:12:"originalname";s:17:"beauty-saloon.jpg";s:3:"alt";s:0:"";s:5:"title";s:0:"";s:4:"desc";s:0:"";s:6:"delete";b:0;s:6:"remove";b:0;}


I want only beautysaloon.jpg with image path.

How can I do this?Please help

Hello

you need to call PHP function
unserialize on the value

Hi thanks,

I tried this.But I am getting this error.

Notice: Array to string conversion in /var/www/html/joomla/components/com_flexicontent/templates/searchlistingpage/item.php on line 1587

Hello


you said above about 1 value and you pasted a string


if you want to do an array of value
then call PHP unserialize on every value:

Hi,

I took only one value in the query.Not array of values.But still I am getting this error.

Hello

do a

print_r($mydata);

does it print a string or an array with 1 value ??