[eluser]ZeusChicago[/eluser]
You must have been typing this as I updated my post above. I did notice I was using the count the wrong way (see bottom of my last post) So I did a test and changed
Oh and I am using the latest version of CI and Datamapper (upgrade from non overzelous) Sorry I didnt mention that before
and echoed the result (which was two) and then checked the profiler output to see the query run was
Code:
SELECT COUNT(*) AS `numrows`
FROM (`subscriptions`)
LEFT OUTER JOIN `subscriptiontypes` as subscriptiontypes ON `subscriptiontypes`.`id` = `subscriptions`.`subscriptiontype_id`
still only outputs one record and the profiler shows the following query
Code:
SELECT `subscriptions`.*, `subscriptiontypes`.`ID` AS subscriptiontype_ID, `subscriptiontypes`.`NAME` AS subscriptiontype_NAME, `subscriptiontypes`.`PRICE` AS subscriptiontype_PRICE, `subscriptiontypes`.`displayname` AS subscriptiontype_displayname, `subscriptiontypes`.`description` AS subscriptiontype_description
FROM (`subscriptions`)
LEFT OUTER JOIN `subscriptiontypes` as subscriptiontypes ON `subscriptiontypes`.`id` = `subscriptions`.`subscriptiontype_id`
WHERE `subscriptions`.`fa_user_id` =1
ORDER BY `subscriptions`.`startdatetime` DESC
which when run from phpmyadmin does produce 2 records....