PHP Debugging help needed...

I'm using a PHP script to call data from a mysql database, and in turn format it using mysql-driven templates. Now, this was working fine before I moved servers, so my guess is my php syntax isn't compatible with the newer server's php/sql or whatever.

However, a near-identical page works without any problems...

Anyway; here's my code. Can someone help me pinpoint what's wrong?


[code removed]

Used when going to http://www.guitar-shopper.com/cat/23/ (I've left error reporting turned on, however those errors shown also show for the script that works, so I don't think that's the problem...)

As far as I can tell, the second SQL request (asking for product info) is just not giving any results, even though using a request through phpmyadmin DOES gives results, and the category name is being parsed (as shown when I echo it).

Any thoughts? This is driving me bonkers, man!

You second 'from' isnt in capitals, not sure if it matters, but I would put it right.

Its also worth printing out your $sql strings to make sure they are coming out as you would expect.

Most likely something to do with variable scope. Don't really have time at the moment to look at it in detail though, but that may give you a starting point.

What's a variable scope? :)

It has to do with where a variable can be written and read from. For example a variable within a function only has scope within that function ie, it can't be accessed directly external to that function. It's said to be a "local variable" and only has "local scope" within the function. Similarly, you can't access variables external to the function from within the function, unless they're set as a global variable or are accessed using $GLOBALS[<variable name here>];

PHP has tightened up on variable scope in the latest releases, which may be why you suddenly experienced problems when you switched the code to a different server.

Got it sorted by using a different variable :) Thanks dudes