Hi,

I have this query now working, but I can't get fields combined in the table, like j17_comprofiler.cb_mv and j17_comprofiler.cb_voortitel (I tried CONCAT)
I also don't know how to get the table over more lines as the table is to wide.

SELECT
j17_comprofiler.cb_mv,
j17_comprofiler.cb_voortitel,
j17_comprofiler.cb_voorletters,
j17_comprofiler.firstname,
j17_comprofiler.middlename,
j17_comprofiler.lastname,
j17_comprofiler.cb_achtertitel,
j17_comprofiler.cb_bedrijf,
j17_comprofiler.cb_functie,
j17_comprofiler.cb_bezoekadresplaats,
j17_users.email
FROM j17_comprofiler
CONCAT (j17_comprofiler.firstname," ",j17_comprofiler.cb_voorletters) AS combi
INNER JOIN j17_users ON j17_comprofiler.id = j17_users.id
WHERE j17_comprofiler.cb_advocaat2 =1 AND j17_comprofiler.approved =1 AND j17_users.block =0

Thanks,

Tom

Hello,

Use the next SQL query:



Regards,
ARI Soft

That was fast!!!

Do you have an answer on the second topic:

I also don't know how to get the table over more lines as the table is to wide.

Tom

Could you provide an image where we can see what do you want to achieve?

Regards,
ARI Soft

You can see it here: www.vrouwholle.com/index.php/nl/ari-advocaat-dienstbetrekking

The table is too wide.

Tom

You can use "ARI Data Table" table widget. It supports scrolling feature. For this set "Choose table type" parameter to "ARI Data Table", "ARI Data Table -> Using jQuery UI themes" parameter to "Yes", "ARI Data Table - > Scroll Width" to 765 value.

Regards,
ARI Soft