PA28 PLT HAS NMAC IN TFC PATTERN AT CFM.

Narrative

I WAS APCHING FLYING CLOUD ARPT AND HAD BEEN CLRED TO LAND ON RWY 27L; WITH INSTRUCTIONS TO ENTER A L DOWNWIND. I WAS APCHING FROM THE SW. STUPIDLY; I TURNED L TO A R DOWNWIND FOR RWY 9R. AS I ENTERED BASE; I ANNOUNCED 'ACFT X ON BASE FOR RWY 27R; CONFIRM CLRED TO LAND?' THE TWR SAID 'CLRED FOR RWY 27L'; SO I CONFIRMED AND MOVED OVER TO THE L RWY. AT THAT POINT; I HEARD A PLT ANNOUNCE THAT 'WE HAVE TFC IN FRONT OF US.' I LOOKED BEHIND ME; THINKING HE WAS ALSO ON APCH. THEN I HEARD HIM SAY; 'WE ARE TURNING TO AVOID TFC.' AT THAT POINT; AS I SAW HIM AT MY 1 O'CLOCK POS; I REALIZED I WAS ON APCH AT THE WRONG END OF THE RWY AND BANKED L TO GET OUT OF THE DEP ZONE. TWR THEN TOLD ME TO TURN R TO A R DOWNWIND FOR RWY 27L. LNDG WAS UNEVENTFUL. I AM COMPLETELY AT FAULT AFTER A FULL DAY OF FLYING. I WILL; FROM NOW ON; POINT WITH MY FINGER TO THE COMPASS COORDINATE OF THE RWY I'VE BEEN ASSIGNED; TO REDIRECT MY BRAIN. IN THIS CASE; I JUST WASN'T PAYING ATTN TO WHAT I WAS TOLD. ALTHOUGH I AM FULLY RESPONSIBLE; I ALSO BELIEVE THE TWR CTLR SHOULD HAVE MADE VISUAL CONFIRMATION OF MY ARR IN THE PATTERN; AND PERHAPS SHE WOULD HAVE CAUGHT MY MISDIRECTION. THIS WAS A STUPID MISTAKE.