showing current KoE on homepage

[Breaker]

hi im using imagecreatefrombmpstring from flux and just want to know how i can get the current king of emperium holder on the homepage.

its inside the mapreg as $koegid thats what i know so far but dont know how to set up a command which will show the current holder (its not like the castle commands for this since they just show you the current castle and with that the holder) x_x help please

SELECT emblem_len, emblem_data FROM cabalro.guild, cabalro.mapreg WHERE varname="$koegid" AND value = guild_id LIMIT 1;

thats my current command and sql query shows it works but i dont know how to put the other things together