Pineapple Plant

Not really gardening as it is in the conservatory.
Last month I used several pineapples as part of table decorations.
On a whim I put two of the Pineapple tops in water
One went mouldy
However the other has now got a long root system and also new leaves in the centre.
Has any Gners grown a plant successfully?
Not sure when and how to plant up and what sort of care they require.
I know I can google but first hand experinnce is always better