I am making a Music database site for University using PHPMyAdmin. Right now, I need to make a process dropdown that allows the user to click on a drop down menu of artist names. When the user clicks on one of the given artists and clicks the send button, I want it to link to a page that contains the songs & details of the artist.. These are the Tables. I need the SQL code in order to successfully link these together/ THANKS
Here is the HTML Drop Down code
-- Please select artist name --
<option>Drake</option>
<option>ILOVEMAKONNEN</option>
<option>Justin Bieber</option>
<option>Kanye West</option>
<option>Kendrick Lamar</option>
<option>Post Malone</option>
<option>ScHoolboy Q</option>
<option>Taylor Swift</option>
<option>Travis Scott</option>
<option>Young Thug</option>
</select>
<input type="submit" value="Send">