Using fputcsv printing array instead of values when with Doctrine and Zend Framewrok?

If you are using the Doctrine 1.1 or higher, you may be able to use the HYDRATE_SCALAR option to force a flat array: $q = Doctrine_Query::create() ->select('p. Name,b. Breed,h.

Behaviour,p. Special_requirements') ->from('PetManager_Model_Pets p') ->leftJoin('p. PetManager_Model_Breeds b') ->leftJoin('p.

PetManager_Model_Behaviour h') ->leftJoin('p. PetManager_Model_Catterypets s') ->leftJoin('s. PetManager_Model_Catterybooking k') ->where('s.

BookingID = k. CatterybookingID') ->andWhere('p. PetID=s.

Pet') ->andwhere('k. SrtDate andWhere('k. EdDate >=?',$today) ->andWhere('k.

Catteryappointmentstatus=1')->setHydrationMode(Doctrine::HYDRATE_SCALAR) and that should give you a flat list.

If you are using the Doctrine 1.1 or higher, you may be able to use the HYDRATE_SCALAR option to force a flat array: $q = Doctrine_Query::create() ->select('p. Name,b. Breed,h.

Behaviour,p. Special_requirements') ->from('PetManager_Model_Pets p') ->leftJoin('p. PetManager_Model_Breeds b') ->leftJoin('p.

PetManager_Model_Behaviour h') ->leftJoin('p. PetManager_Model_Catterypets s') ->leftJoin('s. PetManager_Model_Catterybooking k') ->where('s.

BookingID = k. CatterybookingID') ->andWhere('p. PetID=s.

Pet') ->andwhere('k. SrtDate andWhere('k. EdDate >=?',$today) ->andWhere('k.

Catteryappointmentstatus=1')->setHydrationMode(Doctrine::HYDRATE_SCALAR); and that should give you a flat list.

I'm using Doctrine 1.2.3 but adding this method as you have shown has not worked. – Graham Jun 6 at 13:12 Interesting: could have sworn that should do the right thing. Try doing $result = $q->fetchArray(array(), Doctrine::HYDRATE_SCALAR); and see if that helps?

– Femi Jun 6 at 13:28 No still gives me the same result weird, I can't get on the the Doctrine site at the moment as my connection is crap and keeps it timing out. – Graham Jun 6 at 13:58 Its not your connection: the Doctrine website is crap right now. Could have sworn that should have worked, though :).

You may need to array_map with a function that plucks out the first element if the item at that position is an array. Its inefficient but it will get you there in short order. – Femi Jun 6 at 14:20 thanks for your help, I'm going to leave this for a while until I can get back onto the site.

I've got other query problems to deal with :-) – Graham Jun 6 at 14:24.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.