I have been reading all the tuts and came up with a database and a couple of pages. I know I am getting close to the answer, but just can't seem to get it. 2 pages - one to show lyric titles and then click on the title to show the lyric. the echo?id just won't cross over to the view lyric page, keeps showing the first listing no matter which lyric you click on. here are the pages:

<HEAD>
<TITLE>Select your Lyrics</TITLE>
</HEAD>
<BODY>
<H1>Select Your Lyrics</H1>
<P>
<UL>
<?php

include("connectjunk.inc");

while ($lyric = mysql_fetch_array($lyrics)) {
$id = $lyric["ID"];
$name = $lyric["lyrictitle"];
$lyrictext = $lyric["Text"];
echo("<LI><A HREF='viewlyric.php3?id=$id'>$name</A> ");
}

?>
</UL>
<P ALIGN=CENTER><A HREF="admin.htm">Return to Front Page</A></P>
</BODY>
</HTML>

<HTML>
<HEAD>
<TITLE>Select your Lyrics</TITLE>
</HEAD>
<BODY>
<H1>Select Your Lyrics</H1>
<P>
<UL>
<?php
include("connectjunk.inc");

$lyric = mysql_fetch_array($lyrics);
$id = $lyric["ID"];
$lyrictitle = $lyric["lyrictitle"];
$lyrictext = $lyric["Text"];
echo("<LI>$lyrictitle "."<LI>$lyrictext");
?>
</UL>

</BODY>
</HTML>

I can't even figure out which page it is that has the problem.



------------------
Hutnut
www.roserobin.com