Click here to Skip to main content
15,911,139 members

Comments by Member 8580885 (Top 1 by date)

Member 8580885 19-Jan-12 13:33pm View    
Im not sure how to explain it any better, if the table column headers were Name, Email, FormId there wouldnt be an issue, but the table structure is not like that

under the column header FieldName is the Name and Email fields, and Under the FieldValue column header is the values for Name and Email.

The query string is what i need fixed. this isnt right but may give you an idea:

SELECT FormId, FieldName, FieldValue FROM jos_rsform_submission_values WHERE FieldName='Name' AND FieldName='Email'

And gets the FieldValues from those Table Rows