I have two pages, one to list lyric title and then you click on lyric title to be taken to the page with the lyrics. The problem is, I can't seem to get the view lyrics page to recognize the ID. I know I am doing something really stupid here, but if anyone can spot it and be so kind as to get me going in the right direction....
<HTML>
<HEAD>
<TITLE>Select your Lyrics</TITLE>
</HEAD>
<BODY>
<H1>Select Your Lyrics</H1>
<P>
<UL>
<?php
include("connectjunk");
$lyrics = mysql_query("SELECT lyrictitle, Text FROM Lyrics");
if (!$lyrics) {
echo("<P>Error retrieving lyric from database!<BR>".
"Error: " . mysql_error());
exit();
}
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");
$lyrics = mysql_query("SELECT lyrictitle, Text FROM Lyrics WHERE 'ID=$id'");
if (!$lyrics) {
echo("<P>Error retrieving lyric from database!<BR>".
"Error: " . mysql_error());
exit();
}
$lyric = mysql_fetch_array($lyrics);
$id = $lyric["ID"];
$lyrictitle = $lyric["lyrictitle"];
$lyrictext = $lyric["Text"];
echo("<LI>$lyrictitle "."<LI>$lyrictext");
?>
</UL>
</BODY>
</HTML>
I am starting to pull my hair out over this, and now since I am almost bald I am going to start on the dog next, won't someone please save the dog!!
------------------
Hutnut robin@roserobin.com
www.roserobin.com
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
