I know i'm a little rusty here , so please bear with me. :o
I have the following MySql query:
$sql = "SELECT DISTINCT a.ops_id FROM table_atts AS A
INNER JOIN table_ops AS O ON A.ops_id = O.ops_id
WHERE A.prod_id = 15 ORDER BY O.ops_name ASC";
This query, when run directly in a MySql terminal accurately returns two rows/results: ops_id: 5, 1
However, when run in a php script via $db->Execute($sql) , the result is:
queryFactoryResult Object
(
[is_cached] =>
[resource] => Resource id #1097
[cursor] => 0
[EOF] =>
[fields] => Array
(
[options_id] => 5
)
)
I'm assuming that there is a way to obtain/read out both values??? Thanks to anyone who can enlighten me...
