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>​
Does anybody knows why this doesn't work?
Thanks
If I call the same sql in phpmyadmin it works!
|