Search Database

[dynamiteRW]

I created a database which stores music lyrics.

I have the album, artist(s), song and lyric.

How could it be made possible for someone to search the database using a search field?

[Mordecai]

Try reading this.

[dynamiteRW]

I found a different code which goes like this:

<?
$connection = mysql_connect('localhost', 'username', 'password');

mysql_select_db('wu_wrestleinfo_com', $connection);

$result = mysql_query ("SELECT * FROM music WHERE song LIKE '%$search%'");

while($r=mysql_fetch_array($result))
{

//grab the result
$song=$r["song"];
//print it out
echo $song;
echo "<br>";
}
if(mysql_num_rows($result)==0)
{
echo 'No matches found!';
}
else
{
#matches found
}
?>

What I'd like is to add another code, which will allow people to click on the results, making the results a link to the specific id page.

So for example, if someone types in dogs, it finds if dogs is in the database, then displays the results with the link of the dogs page.

[Mordecai]

See where it echoes out $song? Just change that to a link. If you wanted to switch it to an ID, just change "song" to "id" (every reference to it!).

[dynamiteRW]

When I wrote that, it only gave me the ID number, and not the link.

The links are shown as:

display.php?id=1 or 2, 3, 4 etc.

[Mordecai]

You'll have to tell it to echo out a link. You'd need something like:
echo("<a href=\"display.php?id=$id\">$id</a>");