psl101 - 8:13 pm on Mar 24, 2012 (gmt 0)
Hello, I am making a site where users are able to search for a song, and then clicking on it will take you to a page where you are presented artist information, song name, year, genre, as well as a player on the page (which also uses content from the database. I have already done the search engine part, but what i need help on is for me the toughest part. I want that when the user goes to a certain URL (like [yoursite.com...] Here") with a variable in the url so that it changes the content based on the database. I want to have ONE page where it will display contents from a db. For example: Artist - $artist <br> Year - $yr
I know little about php/mysql. The thing that i dont know how to do is getting ONE page to change with a variable in the url.
The table in the database is like this
TABLE - SONGS
Columns - ID, TITLE, ARTIST, YEAR, DURATION, GENRE, KEYWORDS (for the search), and URL.