Hi:

I have a table that I would like to display and I would only like to display certain fields.

The table is an SQL table.

The Columns are: 'ID', 'Name', 'Last Name', and 'Birthday'

I only want to display 'Name', 'Last Name', and 'Birthday' but do not want to display 'ID'.

How can I do that?

Hello,

You can specify what fields you want to select in SQL query. For example:



Regards,
ARI Soft

And if I want to exclude certain rows?

That is why I have added the ID field. I assumed that would be the best way to exclude some data on a row-by-row basis.

You can exclude select necessary rows with help WHERE construction. For example, if you want to exclude rows with ID 18 and 19, the next SQL query can be used:



Regards,
ARI Soft

This may be a bit more complex.

I want to use the "jos_users" table and have it display all the users except those whose ID I exclude,

Then, I want it to add further data using the "jos_contact_details" table for those users.

Finally, I want it to link to have a link to that specific users contact page (default Joomla page).

Is that possible?

Also, since you are replying to this thread right now, can you please reply to my thread in ARI Photo Gallery and in ARI Fancybox forums.

Thank you.

Hello,

Links based on table record data can be generated with help 'Format' parameter in module settings. Documentation how to use this parameter can be found in 'Description' field on module settings page.

Regards,
ARI Soft