Vertical listing in database - horizontal in web page layout

For my family website I have a Joomla website in preparation. I combine user log in data combined with personal data by running jUser as extension. This works fine.

Elsewhere in the site I want to display personal data. I want to use TBS to gather data from the table, but I cannot manage this.

Extension jUser creates and additional table called 'jos_users_extended_data' and it look like this :


I can get data from the table but only in a vertical way, as it is stored in the database table.

Wat I want is to have data presented in a horizontal way like :



Is there somebody around who can advise me ? Thanks in advance.


Dennis Hoogendonk
The Netherlands

From what I can figure from your post, you intend to use TBS to display data from the database in Joomla...

If you are new to TBS and Joomla - your learning is really two separate issues you need to work on

(1) to get data to display in tables designed to your liking - this is basic learning TBS - I would recommend you begin in the TBS examples here http://www.tinybutstrong.com/examples.php Look at the various 'data' examples and adapt the source code (PHP and templates)

(2) doing the above in Joomla requires installing the TBS extension for Joomla into the Joomla site you have. See http://www.tinybutstrong.com/plugins/joomla/tinybutstrong_help.html

Hope that helps,
TomH

Hi Dennis,

You can solve this by using a adapted SQL query.
For example :

Skrol29

Wow, that's some very clever query stuff.

Thanks for teaching me something with every post you make.

Thanks Skrol29. I'll use the query and try to parse it in tbs.


Dennis

Query works perfect in phpMyAdmin. I only had to parse the query into TBS.

This is the result in the webpage :

<table border="0" cellspacing="2" cellpadding="2">
  <tr>
    <td>Name</td>
    <td>Address</td>
    <td>PostalCode</td>
    <td>City</td>
  </tr>
  <tr>
    <td>{a2.Name;block=tr}</td>
    <td>{a2.Address}</td>
    <td>{a2.PostalCode}</td>
    <td>{a2.City}
</td>
  </tr>
</table>

This is the code :

{tbs}mergeblock=a2;sql=SELECT n.uvalue AS Name, a.uvalue AS Address, p.uvalue AS PostalCode, c.uvalue AS City FROM jos_users_extended_data AS n LEFT JOIN jos_users_extended_data AS a ON (n.user_id=a.user_id) AND (a.field_id=6) LEFT JOIN jos_users_extended_data AS p ON (n.user_id=p.user_id) AND (p.field_id=8) LEFT JOIN jos_users_extended_data AS c ON (n.user_id=c.user_id) AND (c.field_id=9) WHERE (n.field_id=7) ORDER BY n.uvalue{/tbs}

In addition to Skrol29 's MySQL code I have added :

'mergeblock=a2' to define where the result must be placed
'sql = ' as predecessor to SELECT statement


I can now easily extend this SQL line with more fields.


Thanks Skrol29 for your help AND this magnificent Plug-in.


Dennis Hoogendonk
The Netherlands

2 additional remarks - for anyone who wants to learn from my example

1. Make sure the SQL statement is placed in 1 line without any line breaks !
2. I use {} for tbs instead of [] which is the standard


Dennis Hoogendonk
The Netherlands