Query returning no results?

[eluser]matt.asbury[/eluser]
Honestly Xabi, I'm not too sure where to go with this now. With all the details you have given us, the database should be returning something. You could try simplifying the query further:

Code:

SELECT * FROM products

If this does nothing then I'm not too sure what to test next. As long as you are getting results from the other tool you are using, you can rule out problems with the database. You could try commenting out this code and do a manual connection to the database to run a query using classic PHP:

Code:

$link = mysql_connect("host", "user", "password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM tablename", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

mysql_close($link);