Picture this: a website of a youth cheerleading association.
There are seven divisions (aka squads) with about 95 girls.
There are nine games this season followed by 2 playoffs and a championship
game. During the season, there will be a few photo ops in addition to games.
The website features a directory listing of divisions. When you click on a
division, you get:
**************************
cheerleaders
- girl a
- girl b
- girl c
- etc
sponsors
- sponsor a
- sponsor b
game schedule
- game 1
- game 2
- game 3
- etc
**************************
The website is doing pretty well for being just a week old. Fourty-two users
have been approved and given access. Over 120 hits from these users so far.
My daughter is in one of the divisions so I will be there taking pictures of
her for her games only. Remember, this is youth ball. Each division plays
against the same team every Sat. Therefore, there will be 7 games each Sat for
9 weeks.
I have an photo uploading script that works already. This is essential
because I will not be taking all the photos - only my daughters division. The
parents need a way to upload their photos to share with others.
That is my problem. I have decided to upload the photos to a file rather
than into a mySQL table. I just need a way to organize the uploads to make
sure when mom of girl-a uploads a photo of her at game 6 that clicking on the
division, the girl, or the game will show that picture without having multiple
copies in multiple locations.
I hope this makes sense as my brain is fried from thinking about solutions at
this point. Someone, please help this PHP/mySQL noob !
Thanks in advance.
---------------------------------
Groups are talking. We´re listening. Check out the handy changes to
Yahoo! Groups.
[Non-text portions of this message have been removed]
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/