Hello,

Could you send SQL dump of #__rsform_submission_values table by email?

Regards,
ARI Soft

Hi -

I am using rsforms and what I am trying to accomplish is to have a dynamic sql statement generated and to have the data presented based on user input as illustrated in attached.

As an example, if end user selected "Italian" in cuisine drop down box, only those restaurants meeting selection criteria would be displayed.

Thr dropdown boxes are all prepopulated via rsforms SQL statement.

Thanking you in advance for your assistance with this issue.

Hello,

You can read how to show data from "RS Form" extension here.

Regards,
ARI Soft

Hello and thank you for your reply to my posting.

I'm not quite sure that I have explained what I am trying to accomplish clearly,or Perhaps I am not understanding your response.

What I want to accomplish is to retrieve and display data from a table based on user input to RSforms drop down box not the RSforms values that the user selected.

An example of a Query:

SELECT
CompanyName,WEB
FROM sheet4
WHERE
City = (whatever user selected in RSforms City dropdown box)
AND
cuisine = (whatever user selected in RSforms Cuisine dropdown box)
(whatever user selected in RSforms City dropdown box)

Also, if user does not make any selections from RSForms dropdown box(s), then retrieve all records.

I have purchased both Ari SmartContent and DataTables products as I believe your last response was based on Ari DataTables.

Thanking you in advance for any assistance you may provide towards the resolution of this issue.

Find the answer here.

Regards,
ARI Soft

How to display
"FieldName" as header table and
"FieldValue" as content of FieldName

Table A using the source
-------------
SELECT
FieldName,
FieldValue
FROM
#__rsform_submission_values
WHERE FormId = 1
AND
FieldName IN ('Nama','Email','About','Message')
ORDER BY SubmissionId DESC
---------------

From Table A to Table B




Thanks..