Need a bit of assistance (php/mysql)

[Sami]

I'd need a simple survey / questionnaire system for the beta... I have already googled around and found few scripts but they were really not suitable. So if anyone knows a system that I could use, drop me a note.


The thing what I am looking for is:

- a script that is used to run a survey for the beta test members (questions like "rate this game: 1-5", etc.etc.), with a admin panel to view the results.

- must be fully installable to our servers (= not using third party servers) and must use php/mysql

- ability to track who has answered the survey and who has not (compared to a predefined list of people who are allowed to take the survey)

[gustavoramos]

Hey, Sami...

Mmm, think I can help you on this. I had to make some surveys to my company intranet, and used a script called PHPSurveyor. I've googled around to reply your post, and realized that the project has a new name, under LimeSurveyhttp://www.limesurvey.org/content/view/13/80/lang,en/. If you need something related to the coding, I can help you, as I modified some modules in the PHPSurveyor to adapt it to my needs, and having downloaded the new one, realized that the codes is basically the same...

Hope I could help in anything!

Cheers!

GustavoRamos

[gustavoramos]

Hey, sami.. I was thinking about it today... the system has a module where you register users to do the survey. This list is in one table at the database, and each user (or group of users) has it's rights to vote in this or that survey. You could make a .sql file, with the beta testers id's, for example, and the system will let only that people to do the survey. And you could make even reports. Let's say that in the survey DB there's a column called SurveyDone. While "0", the survey was not done. When the user submit the form, besides the whole data, it writes "1" in that column. So.. you can do a php code just to search this "1" on the database.. something like:

INSERT INTO SurveyDone (done) VALUES ('1')

and

SELECT done,userid FROM SurveyDone WHERE done='1'

it'd be something like this... if you need me to clarify something (i think you will not!  ) Just let me know!

Cheers!

[Sami]

Yep thanks, this looks best so far.

[gustavoramos]

So, Sami, just for curiosity...

Got wat you wanted? 

Cheez;

- PJA