Search results

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...