Query Problem

[Anon]

I'm having trouble with a query that worked fine yesterday. When I hit the page this morning it didn't worky anymore

You can see what's happening here http://www.eyecravedvd.com/dvd/index.php?display=easteregg

The strange part is I get some results. If you click on the letter 'M' in the quick search it returns a value. Same with the later 'P.' There are few that return - sorry no results found when I know there are some for that letter. Here is the piece of code. Any help here would be grand.

Shane

  $easterQuery = mysql_db_query($theDB, 
     "SELECT * FROM $easterEggTable WHERE " .$easterEggArray[DVD_ID]. "=$dvdId")
  or die ("\n<BR>Invalid EasterEgg Query<BR>");
  $theEasterEgg = mysql_fetch_array($easterQuery);
  $eeLink = $theEasterEgg[ $easterEggArray[EE_ID]];
  @mysql_free_result($easterQuery);
}

[[deleted]]

"SELECT * FROM $easterEggTable WHERE " .$easterEggArray[DVD_ID]. "=$dvdId"

that can't work. just do

"SELECT * FROM $easterEggTable WHERE $easterEggArray[DVD_ID] = $dvdId"

and mysql_db_query() returns false on failure, so may be you do this to get a error msg more detailed:

if(!$easterQuery) echo mysql_error();

give it a try

ali

[Anon]

I get nothing with that statement - however I am getting a screen with this error now

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home0/eyecrave/public_html/dvd/mainPage.php on line 735
Abyss, The: SE 20th Century Fox 1989 PG-13 5.1/2.0
You have an error in your SQL syntax near '= LIMIT 1' at line 1

[[deleted]]

please post the code, because it seems like you modified it. In the old query there was no use of LIMIT.

let's see

ali