Need help badly....guy problems

Well, the guy is giving you obvious signals that there is no hope. It is a waste of time for you to pine for someone who has so clearly slammed the door.

The good news is, like you said, you have other prospects.

Very true...I just know he is a great friend. But here lately I have realised that there may be no hope and all Im doin is making myself look stupid

This is kind of a part of growing up, you start to understand the signals other people are giving off. And sometimes you misinterpret them, or your heart just leads you down this garden path and suddenly you have a crush on someone who was, essentially, just being normally nice to you and (in their eyes) not treating you in a particularly special manner.

You've gotta let it go. This is not always easy but, ultimately, it is what you must do.

All I can say is thank you

You're welcome.

Time for me to go make dinner.

Maybe you are subconsciously picking someone who is unavailable as an excuse to avoid having a more equitable relationship. This guy was amazingly direct it telling you it isn't going to happen with him, seemingly to the point of being insulting and you are still pining over him? Maybe this is more "fear of flying".

Just take him! Treat him for what he is.... a piece of meat.

You want him, he pushes you away. So exciting and no real relationship there. I agree, he's "safe" for you to spend time on because he's a fantasy.

Try to figure out what it is that is so attractive. (The way he moves, his voice, his body, his sense of humor??) What part of him is so appealing to you?

Then go and find another guy with that same attribute.
And hurry up. This takes time and energy and is fun.

That could develop into a BIG problem down the line.
See if you can analyze what makes you feel this way; perhaps your family dynamics or feelings of low self-esteem.
It's worth dealing with this now.