DB Images

No, im using this

select id, ‘https://www.google.co.uk/images/srpr/logo11w.png,’https://www.google.com’ as link from wp_posts limit 2

PHP is:
$a = explode(“,”,$value);
return “<img src='”.$a[0].”‘ />“;

but when i save it, the snippet moves to the column name for some reason.

Yes sorry, the snippet update bug is a typo bug which i just saw today and have just fixed in 0.5.5.

Still not working, try this

select id, ‘https://www.google.co.uk/images/srpr/logo11w.png&#8217;,’https://www.google.com&#8217; as link from wp_posts limit 2

with
$a = explode(“,”,$value);
return “<img src='”.$a[0].”‘ />”;

OK that SQL generates two columns and the PHP is expecting one column containing both the image URL and the link URL separated by a comma. I have updated the FAQ with the same example from further up this thread and retested it. I would try creating a new DBView (refresh the page) and add just the SQL alone which should give you:

https://www.google.co.uk/images/srpr/logo11w.png,https://www.google.com

then add the PHP snippet.

thank you so much for your help, we got there in the end. Have a look at the final table

https://www.predictresults.co.uk/full-list-of-football-tips/

It would still be great to hide the final column but I dont want to mess with the CSS.

if you ever work on hiding columns please let me know.

OK!