Php Returning Multiple Rows

When I echo my query on screen and run directly in SSMS I get ONE row returned, which is exactly what I am after. When I run this query in my php I get multiple rows returned (see

Solution 1:

$db->loadObjectList() is the Joomla function that will return a list of rows. If you want just one row you should use $db->loadObject() instead