SQL query with prev & next links

[Anon]

Hi,

I am trying to write a script that will load data from a row, display it, and at the bottom of the page have links to the data from the previous row and the next row.

ie: Let's say the page displays lyrics from a db.

The query string will fetch the result for say song #75

$result = mysql_query("SELECT * FROM songs WHERE song=$song",$db); \ in this example $song=75

$myrow = mysql_fetch_array($result);

print("<p>&nbsp;<br />");

printf("<span class=\"highlight\">Album: %s</span>\n<br />", $myrow["album"]);

printf("<span class=\"song\">Song: %s</span>\n<br />", $myrow["songname"]);

printf("<span class=\"songcredits\">Author: %s</span>\n<br />", $myrow["author"]);

printf("</p> %s\n", $myrow["lyrics"]);

Now after the lyrics are displayed, I would like to put two links at the bottom of the page as follows.

<a href="?song=74">Name of song #74</a> | <a href="?song=76">Name of song #76</a>

How do I do this? and such that if there is no song #74 or song #76 it won't give me a bad link?

Thanks in advance!

[Anon]

Nevermind I figured it out myself 🙂

I added the following:

// prev & next links
$one = 1;
$songn = $song + $one;
$songp = $song - $one;

if ($songp == 0)
{ print"<p>&nbsp;</p><p class=\"bodysmalldark\"><strong> \n"; }
else {
$resultp = mysql_query("SELECT FROM songs WHERE song=$songp",$db);

$myrowp = mysql_fetch_array($resultp);
printf("<p>&nbsp;</p><p class=\"bodysmalldark\"><strong>&#171; previous song: <a href=\"%s?song=%s\" title=\"previous song\">%s</a> |\n", $PHP_SELF, $myrowp["song"], $myrowp["songname"]);
}
if ($songn == 125)
{ print" <a href=\"?\" title=\"lyrics\">back to lyrics</a></strong>\n"; }
else {
$resultn = mysql_query("SELECT FROM songs WHERE song=$songn",$db);
$myrown = mysql_fetch_array($resultn);

  printf(" <a href=\"?\" title=\"lyrics\">back to lyrics</a> | next song: <a href=\"%s?song=%s\" title=\"next song\">%s</a> &#187;</strong></p>\n", $PHP_SELF, $myrown["song"], $myrown["songname"]);

}

[jaydj]

hello Riffola,

if ($songn == 125)
{ print" <a href=\"?\" title=\"lyrics\">back to lyrics</a></strong>\n"; }

what's the 125 for ? just curious cause I have a lyrics based site as well...

Do you provide context-sensitive search ? can you search for a line in the lyrics and you can retrieve the song title and artist ?

Hope you can e-mail me privately so we can talk more about our sites. Thanks !

jaydj =)
[e-mail]