#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Mammoth Spring, Arkansas
    Posts
    3
    Rep Power
    0
    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
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,648
    Rep Power
    4493
    This is an old question, so hopefully you've answered it already. the problem is your first select statement. you're not selecting id, only lyrictitle and text.

    ---JH

IMN logo majestic logo threadwatch logo seochat tools logo