Hi Tom!
Well, your problem could be of various reasons.
Is the connection to your database open?
Do you actually "select" anything? Use this code snippet to test your query (after $raw=MYSQL_QUERY($query)):
PHP Code:
if(!$raw)
echo "error: ".mysql_error();
And this, to see if you got any results:
PHP Code:
if(MYSQL_NUM_ROWS($raw) > 0)
echo "results";
Next one. I encountered some problems when using a "dotted" fields in an array as well, try this:
PHP Code:
$query="SELECT products.id AS ProductID FROM products";
$raw=...
$arr=...
echo "Product ID: ".$arr["ProductID"];
Just an example, but I guess you get the drift.
Hope that helps!
--
Till