when you display the music in the table, each artist could be a link:
<table>
<tr><td><a href=\"artistquery.php?artistname=raffie\">Raffie</a>
</td></tr>
When the user clicks on the link, the page will be displayed.
Mat wrote:
I have set up a music website using html, php and my sql. When a music genre is selected a table is built and displayed. The table contains, amongst other things, an artist name and record label fields.
What I would like to do is to be able to click on an artist or label and for another table to be displayed containing all the records by that artist or by the label.
I don\'t want to use a form if I can help it (I don\'t want a submit button) but need to pass the artist name variable to a search results page that can be used to retreive the relevant details from the database.
The principle of passing a variable to another page doesn\'t sound to difficult but I can\'t work out how to do it.Has any got any ideas how I could do this in php please.
cheers,