I have a one page survey form at my website contains 24 questions.
I created it using PHP / MySQL connectivity, form processing is working fine now.
But I need to know, how do I create a Search form (on php) using check-boxes &/or Drop-down menu, to search the Survey table (inside MySQL database) for specific fields or columns. For example, I want to view total number of answers for question2 & question7 & question9, and I'll have to check the check-boxes or select multiple options in drop-down list for my desired results to display AFTER I click the submit button.
And the next page (after collecting required columns or data) should display only what I selected to view not the entire table.
Well I'm new to php/mysql stuff, so my question might not make sense but I still need a detailed guidance or you can just write the script here then I'll play with it ........ If you want to know more info, please ask.
Any help will be greatly appreciated
I created it using PHP / MySQL connectivity, form processing is working fine now.
But I need to know, how do I create a Search form (on php) using check-boxes &/or Drop-down menu, to search the Survey table (inside MySQL database) for specific fields or columns. For example, I want to view total number of answers for question2 & question7 & question9, and I'll have to check the check-boxes or select multiple options in drop-down list for my desired results to display AFTER I click the submit button.
And the next page (after collecting required columns or data) should display only what I selected to view not the entire table.
Well I'm new to php/mysql stuff, so my question might not make sense but I still need a detailed guidance or you can just write the script here then I'll play with it ........ If you want to know more info, please ask.
Any help will be greatly appreciated