Im so upset ;( i really do love him?

ok, i have liked my brothers friend for the last year. a few months ago while out he kissed me and he was being very friendly towards me, im completly in love with him and thought about him everyday when he was away at university, i would play out in my head what it would be like when hes back and that wed be together, almost to the point of obsession, ive neve rever loved anyone this much. Then last night i went out clubbing with some friends and he was there with my brother, i got quite drunk, and took him over to a corner and was being really touchy with him and telling him i really liked him, but he jsut told me straight out that nothing can ever happen as hes my brothers friend, and literly pushed me off him, i spent the rest of the evening crying and i feel so so stupid. hes all ive thought about for weeks and i jsut dont know what 2 do with myself, and im jsut so embarred, now all my brothers friends no about it anf ill be so embarresed when he coems over our house.