[Myztiq]

Well im just starting to learn php (as in began today).... I intend on creating a php survey for my sister. She is doing a survey of 99 questions, each question has about 3 total answers, some answers will need to be just plain text... her goal is to get all these answers into a simple Excel format since her program to analize the data uses excel. As of now she is just using good ol paper and pen for the surveys but in 3 weeks she is going to australia to conduct this on a much larger scale. 500 or more participants in this one survey a month or so... So.... If anyone has any experience and is willing to coach me along on this. I AM NOT LOOKING FOR SOME 1 TO JUST GIVE ME THE SETUP. I want to learn how to do it so that in the future i may A. Teach others and B. Make my own. I was thinking of using MySQL for this but again ive never touched the program. Things im using so far are....

Portablewebapp
Programmers Notepad for php
MySQL Server 5.0
MySQLCC

Anyone willing to help me with this process.. Best way in my eyes is exchange of AIM accounts or something for chatting process...

I am looking for a mentor on the subject and if any kind person is willing to help me i would be much appreciated. I typically fall in the troubleshooting category for computers and with windows xp as the main system i use. Thank you for taking your time to even read all this and help everyone on this forum.

*edit*

I just thought of something.... Couldnt i just make a form style page with all 99 questions on it and when the person hits submit the action page will make their answers into a simple excel format? i need the answers to span across horizonally. Only big concern i have about this is how to get the action page to submit all those answers into certain cells and i guess i could make an if then statment to determin if the cell is filled or not then move down 1. however if someone leaves an answer blank then im sol with that. Mabee just use a single if then statment for the first field (name) then have the location up and down be dependent on that... Anyone know how to make a html form convert its answers into an excel spreadsheet? if you either wish to coach me along the process or give me a couple helpful links i would be much appreciated!

*end Edit*

[Genidiot]

Just a quick thought ... have your code save to CSV (comma-separated values) format, easily imported into Excel. I'm a bit farther up the PHP learning curve than you with different end goals, but I'm guessing integrating Excel and PHP directly would be a pain. CSV should be easy to do though.