I am designing a database with a search feature for music and I am trying to get the title of a song on a search results page to display the lyrics to the song when the title is clicked.
This is a bit of the script I am using. Please any suggestions would be helpful.
<?php
...
$id =...
I am trying to link one variable in the search results to its corresponding variable which is in the same row but on a different field result.
For Example (title and lyrics are field heads)
title || lyrics
father || am i so proud to be your son...
If I search for father, I get father in the...
I have two different tables with related information, both use a field with a common id as a means for matching results between them.
I am trying to search from the two related tables, but my script also produces some results that do not match. The matching key field is SongNo (e.g 1945, 1985...
I have two tables in my database
This ("----------") represents the end of a field. and the last field (SongNo) is the key used to match the two tables.
[table: "Writers"]
title------------------------Author-----------------SongNo
We are, we are-------Michael J--------------1691
You got the...