I need to learn PHP and MYSQL, and the best way id going to design a site that uses forms and a database. My problem is that I have no idea what to make. My best idea was a site that would allow users to submit their best scores/times in video games, like Super Punch Out or Mario Kart. I think that it's a decent idea, but there has to be a better idea out there. Does anyone have one?
For ideas to a site to make in php/mysql, first of all, we need to know why do you wanna learn these languages?
I mean... What are you going to do after you learned them.. If you going to make sites on games, make a simple site about games, if u going to do something related on what u going to do later, is the best way to learn while u doing something u like!
ps. Make a forum as starting.. It was where I started!
Like the others said, you need to do what you like.
If you want to build up like a site that gets a lot of activity on the forums, or just traffic overall, you need something that will keep members comming back. You need to do something that people need, or enjoy.
Do you want to "know PHP" because you want to put it on your resume? What do you expect to be doing with that knowledge?
I did membership for my site first and then added a member messaging system. Both were pretty straightforward to do and were good for learning.
Incicentally, I would like to thank once again all the Frihosters who helped me.
Think the best thing you can do is to pick something that really interests you. That will give the drive to want to make it the best you can and consquently will give you the best results. Sounds like you want something that is interactive and helpful to people maybe.
You could always share what you learn with others starting at ground zero. For some people they have no idea what a PHP is so you could start there and then add knowledge as you progress. Go anywhere that your study takes you perhaps. A helper site for people interested in making web pages for the first time?
Pick a site you like, an dtry to replicate it as best you can. Not for profit or anything mind you, just for a learning experience and to see if you can do it. Make a simplified version of digg.com, or youtube.com or facebook.com
Just for the hell of it.
Moved to the Web Design forum.