That is sad news my brother with the 0 in his name. There are plenty of songs I can think of, but if you have Weezer's
Pinkerton you could pop that in and listen to it all the way through. Besides being a masterpiece it is a great album about a guy who gets betrayed by women. Or you can just pop in Beck's
Sea Change and just cry out your eyes. Besides being the best album of 2002, it is also arguably the best album by a man going through heartache of all time. I don't know your exact situation but here are some great sad and happy songs I love:
--R.E.M. - "Everybody Hurts" (Poignant, great lyrics, even better music)
--Jackson 5 - "Never Can Say Goodbye," "I'll Be There"
--The Beatles - "Help!" or for happy check out "Rocky Raccoon." A great song with Paul at his most playful best. This might be my most favorite song by them.
--Beck - "Lonesome Tears"
--Nine Inch Nails - "Something I Can Never Have"
--Drive-By Truckers - "Goddamn Lonely Love"
--Fleetwood Mac - "Go Your Own Way"
--Incubus - "I Miss You"
--Yeah Yeah Yeahs - "Maps"
--John Lennon - "Love"
--Of Montreal - "The Past is a Grotesque Animal"
--Radiohead - "True Love Waits," "How to Disappear Completely," "Motion Picture Soundtrack," "Fake Plastic Trees"
--Antony and the Johnsons - "Hope There's Someone"
--U2 - "With or Without You"
--The Bee Gees - "How Can You Mend a Broken Heart"
--Tom Waits - "If I Have to Go"
--Bob Dylan - "To Make You Feel My Love"
--The Beach Boys - "God Only Knows" (Who knows if this is a break up song, or a love song, but it is one of my top five songs of all time. Featured in an episode of the classic show, "The Wonder Years," when Winnie tells Kevin she doesn't want to be with him, the song fit nicely.)
-----
If you don't love me, I'm sorry.