Categories > TinyButStrong general >

Why this isn't working???

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: eugeni
Date: 2010-03-01
Time: 00:46

Why this isn't working???

I'm a newby in joomla and tbs but I've done a simple sql and it worked, but with this one only shows the fields as they are in the template instead of the data in the database.
The template is:

<!-- TBS $key = (isset($_GET['key'])) ? intval($_GET['key']) : 0; $TBS->MergeBlock('m','mysql','SELECT eur_paisos.pais, eur_paisos.pais_img, eur_moneda.id_moneda, eur_monedes.facial, eur_monedes.unitat, eur_monedes.monedes_img, eur_moneda.tinc FROM eur_paisos INNER JOIN ( eur_monedes INNER JOIN eur_moneda ON eur_monedes.Id_monedes = eur_moneda.ma_monedes ) ON eur_paisos.id_pais = eur_moneda.ma_pais ORDER BY eur_paisos.pais, eur_moneda.id_moneda'); --> {tbs}embedded{/tbs}    
<table cellpadding="0" border="0">
    <tbody>
        <tr>
            <td width="100" colspan="2"><strong><span style="text-decoration: underline;">País</span></strong></td>
            <td width="100" colspan="2"><strong><span style="text-decoration: underline;">Monedes</span></strong></td>
            <td width="10"><strong><span style="text-decoration: underline;">Tinc</span></strong></td>
        </tr>
        <tr>
            <td width="20"><img src="[m.pais_img]" width="16" height="11" /></td>
            <td><strong>[m.pais;block=tr]</strong></td>
            <td width="20"><img height="12" width="12" src="[m.monedes_img]" /></td>
            <td>[m.facial] [m.unitat]</td>
            <td>[m.tinc]</td>
        </tr>
    </tbody>
</table>&#8203;

Does anybody knows why this doesn't work?

Thanks

If I call the same sql in phpmyadmin it works!
By: TomH
Date: 2010-03-01
Time: 03:38

Re: Why this isn't working???

Can it be that your tag
<!-- TBS

has a space before the "T" in TBS ??

The example in the Joomla plugin manual has no space.
By: eugeni
Date: 2010-03-01
Time: 16:45

Re: Why this isn't working???

You're great!!! Thanks a lot!!! I've spent a hull day looking what was happening and was not able to see that!!!