Journal - Second Quarter:

11.06.02 - Reorganized the main page for second quarter. Also, I've decided to put the movie reviews on hold an concentrate on song lyrics/translations for now because they are easier to find/write. Thus, the PHP code will be easier to write and I will have something to show at the end of the second quarter.
11.08.02 - Added a shows_genre linker table for genre output later on. Also began on the song lyrics database structure, namely created the songs and bands tables.

Goal for this week: Finish the song lyrics database structure
11.11.02 - Created the people, and albums tables.
11.13.02 - Created the bands_people, and albums_songs linker tables. Entered the band and people information for the first two bands I will concetrate on: GARNET CROW and Zhou Jie Lun.
11.15.02 - Entered data on the first album I will concetrate on (GARNET CROW's first soundscope) and the songs in it. Also began translating a song on the album. Moreover, created the design page for the database structure of song lyrics.

Goal for this week: Create the layout of my website using fundamental PHP code, like include() and echo() statements.
11.18.02 - With help from www.php.net, I split up the source code for my website into segments to use with include() statements.
11.20.02 - Created recursive include() statements to finally end up with three include() files for every page on my site, head.php, beforecontent.php, and aftercontent.php.
11.22.02 - Split the HTML code even further into leftmenubar.php, rightmenubar.php, and dbConnect.php.

Goal for this week: Finish writing a simple version of the script for testing.
11.25.02 - I added a random image php script to show random images of the movies and anime series that I will review on my website. To see what I mean, take a look at the template for my page here.
11.27.02 - Read the MySQL section of www.php.net's documentation and started on a simple version of lyrics.php.
11.29.02 - Thanksgiving Break

Goal for this week: Add display functions on the script and allow it to receive parameters.
12.02.02 - Wrote the default portion of the script, as in what is shown when no parameters are passed to the script. The default case can be viewed here.
12.04.02 - Wrote the function when a song_id is provided. This is what you get when you pass a song_id.
12.06.02 - Edited the song_id function to display the song lyrics in the original language, the Romanized song lyrics, the translated song lyrics and the notes about the song.

Goal for this week: Finish at least one song lyric completely to test the script.
12.09.02 - Typed in the lyrics for Natsu no Maboroshi.
12.11.02 - Snow Day
12.13.02 - Changed if() statements to if else() statements to make the script function as it was supposed to. Added in more display functions, everything but the song analysis displays now.

Goal for this week: Completely finish one song so I can test the script.
12.15.02 - Began to translate Natsu no maboroshi.
12.17.02 - Typed in the romaji (Romanized Japanese) lyrics for the song.
12.19.02 - Updated logs and put the raw php code on the main site. Also, added sorting functions to the script. Now you can sort the songs by song_name or song_name_translation.
-- WINTER VACATION --

Goal for this week: Finish the draft for the project poster.
1.06.03 - Worked on poster page located here.
1.08.03 - Updated the project poster page and this journal.
1.10.03 - Revised the project poster information to reflect the research aspect of my project more. To understand the subtleties of database design, I read a book about normalizing databases, that is, removing useless information in databases to reduce the size of the database.

Goal for this week: Make the layout for the band info pages.
1.13.03 - Wrote the function when a band_id is provided. This is what you get when you pass a band_id.
1.15.03 - Wrote another iteration report, look at it here. This is what you get when you pass a band_id and a sort_by.
1.17.03 - Added the case when a band_id and a sort_by is provided.

Goal for this week: Finish materials and get ready for the end of the quarter.
1.22.03 - Updated this journal and commented code.
1.24.03 - Stared gluing and designing the project poster.

Goal for this week: Same as last week, finish the poster up.
1.27.03 -