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
