newbie lost in mySQL

juicyjuice

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

rachel2004

Since you're coming from an object oriented background, you may want to look into PEAR:

http://pear.php.net

and for PHP classes:

www.phpclasses.com

I have not explored it any great depth, but I have seen some people extoll how great it is.

For a pretty good PHP/MySQL intro, the Sitepoint website has a pretty good article. Actually, they have a lot of pretty good articles.

www.sitepoint.com

This may not necessarily help you with your specific project, but at least you have a few more resources available to you if you weren't already aware of them.

Hope this helped.