We have a specific way the data from the surveys needs to be exported. We have a program which was written for an older version of LimeSurvey, but does not work with the newer versions.

I am trying to query the database for the answers to a survey by a specific participant. I understand from the manual that the answers are tagged by the token for the participant. I have been able to find and query the participants token, but I cannot find anywhere in the database where the participants answers are stored.

Any information on which table the answers to the surveys is store would be much appreciated.

We are using Version 2.58.0+170104.

Thank you!

Hi, find out your survey's database id (survey id) and database table prefix (may be empty). Participant answers are stored in database table [prefix_]survey_[survey_id].

table {prefix}_survey_{surveyid}

Well that's the short answer...

sorry I haven't seen you answered in the while ^^

Thank you both for your responses, I now see the answers in that table. I think my test survey didn't have enough questions to catch my eye, but I see the answers now.

Thanks!