I am developing a custom block which should display only three fields of the latest entry in a database activity, the first one being an image (something here... is the footer ):
I have managed to do this with the following SQL statement but for obvious reasons it displays the image name and not the image.
I also noticed that the database activity has one main table (mdl_data) with reference to all DB activities in the site. So I will also need a complex SQL to get e.g. only the records of the DB-Activity with id 1.
Could anyone guide me with the complex SQL and the displaying of the image from the database?
Thanks in advance!
PS. I am a newbie in Moodle Dev