Hi

Very sorry I am now very confused. I have been able to write MSQL queries to display joomla database tables and even the join tables. In trying to get to this technique from user input such as submit forms, is it a different way of approaching it? I have used these queries on databases what is different now?

To help me understand can you please show me step by step of this technique and I promise you I will not disturb you for a long time.

Kind regards

We provided before the solution how to search by a user input. Create a data source with the SQL query, use this data source in "ARI Smart Content - Data Table" module, load the module into an article and insert the HTML form into the article.

Regards,
ARI Soft

Hi

Thank you for reply. I have followed the steps that you outlined and I am getting the table output but there is no data. When I submit the request say an id, there is no change that - there is no data.

Please check my code:

SELECT id, name, nric
FROM #__students
WHERE
nric LIKE CONCAT ("%", {$REQUEST: searchStr|empty: ' '}, "%")

Kind regards

Hi again,

with the code given last, it does not respond to my submit data, but will print all data in the table with white spaces for example if a white space exist between between name data.

Help still needed

Kind regards

Could you provide a link to a page where the module is used and a temporary access to your Joomla! backend by email so we can investigate the problem?

Regards,
ARI Soft

Hello,

Just provided the temp access as required.

Thank you for your help

Kind regards