Won't Return Proper Value

[Anon]

I've got a piece of code that will populate the table I have but it will not add the proper link. The reason this is confusing is because if it is returning the proper title why wouldn't it grab the right Id for the link?

Here is the link to the page to see it in action http://www.eyecravedvd.com/dvd/index.php?display=easteregg

Here is the code that is displaying the titles

  $easterQuery = mysql_db_query($theDB, "SELECT * FROM easterEggs INNER JOIN
                dvd ON easterEggs.dvdId=dvd.dvdId")
    or die ("\n<BR>Invalid Easter Egg Query [$eQuery]<BR>");
  $theEasterEgg = mysql_fetch_array($easterQuery);
  $eggId = $theEasterEgg['eeId'];
  @mysql_free_result($easterQuery);

[Anon]

looks like you got it fixed?

-Ken

[Anon]

Nope, I can get it to display the title but I can't get it to grab the info for the link. It's almost as if it's not returning the value I'm asking for. It's not returning the eeId or eggId. I get nothing - there are two table and I'm using dvdId to join them. I want to grab eeId where easter.dvdId = dvdId but all I get is nothing

So that's why I don't understand why it would grab the titles and not the links.