Query List, How to make one column using 2 and 3 data.

[thekids]

Dear All,

In db Mysql, i create table with several with colum,

----------
jos_staff
----------
id
name
bachelor
master
doctore
email
---------

if i have a data :
P51229, Thekids ; B.Sc [MIT] , M.Eng [Tohoku] , P.hD [MIT]

I create Query List with colum like this :

------------------------------------------------------------------------
| no  |  id      | name     | education                                  |
------------------------------------------------------------------------
|  1  | P51229  | Thekids | B.Sc [MIT] , M.Eng [Tohoku] , P.hD [MIT]   |
------------------------------------------------------------------------

How to make like this, exactly a column 'education'

thank you very much

thekids

[fvds]

A simple approach:
In the querylist, create for education three columns where you put the bachelor, master and doctore va;ues. In the column name of bachelor you put the value "Education" and set the colspan to 3. That will give you three values (if in the database).

A more complicated approach:
You can access the $row from the querylist value. $row holds the current table row and can be accessed like $row->bachelor for the value of bachelor. You can concatenate the values of bachelor, master and doctore with this $row.

HTH

[killerB]

To be a bit more precise put this code in the education column.

Code:

<?php return $row->bachelor.', '.$row->master.','.$row->doctore; ?>

Hope that helps.