You Are Here:
TopLyricLyric Search > Lyric Search Msg22441

Lyric Search

How to build a lyric database
Date: Thu, 27 Mar 2003 16:19:23 +0000 (UTC)
Newsgroups: macromedia.dreamweaver
Size: 1,023 bytes
I wonder if anyone could guide me. I don't know much about php/mysql and was hoping Dreamweaver MX would help me do this.
I want to make a lyric database. It will consist of a search page where users can search the database (this will be an html page in my site) & an admin section where data is added/edited to the database.
I've created a database and dreamweaver is connecting to it ok.
So what do I do next?
I'm not sure I understand the tables side of a database. Can someone explain to me how many tables I need to create. I am assuming these are used to store certain information. So would table 1 be Title? Table 2 Date? Table 3 Lyrics etc? is that how it works?
Do I create a search form on my html page? If so, how does that connect to the database?
And how are the results displayed? I assume a results page must be created but how does it write the results on to my html page?
Sorry for my newbie question. If there are any good articles, I should read please point me in the right direction.
Many thanks

Site Categories:
• Broadway
• Child Song
• Christian Music
• Classical Music
• Country Music
• Dance
• Gospel Music
• Guitar Music
• Jazz
• Karaoke
• Lyric
• Metal Music
• Music
• Music Download
• Music Video
• New Age
• Rap Music
• Reggae
• Rock
• Wedding Song
• World Music