newbie lost in mySQL
Posted: Tue Jun 15, 2004 10:58 am
Hello All!
I am new to the forum and relatively new to php and mySQL. I have programmed for years in C++ and Java and now and trying to pick up php on the job. I am starting a new project in which I need to analyze attendance information and make it so that an idiot can go into a website and it will spit back out the analysis. I have tons of data and new data needs to be entered every time an event occurs to add to the averages. I want to throw it all into a mySQL database and have phpMyAdmin installed and ready to go. I guess my problem is that I do not know how to go about designing the database so that I can access all. Each event has an entry for each person entering, including time of access, gate entered, type of ticket, and a few other random things. Any ideas? Or can someone point me to a resource that may help. I have a few books, but none have examples that help much in such a large project.
Thanks
I am new to the forum and relatively new to php and mySQL. I have programmed for years in C++ and Java and now and trying to pick up php on the job. I am starting a new project in which I need to analyze attendance information and make it so that an idiot can go into a website and it will spit back out the analysis. I have tons of data and new data needs to be entered every time an event occurs to add to the averages. I want to throw it all into a mySQL database and have phpMyAdmin installed and ready to go. I guess my problem is that I do not know how to go about designing the database so that I can access all. Each event has an entry for each person entering, including time of access, gate entered, type of ticket, and a few other random things. Any ideas? Or can someone point me to a resource that may help. I have a few books, but none have examples that help much in such a large project.
Thanks