Hard drive not responding HELP!

X is always the recovery, as far as I know.

I've tried booting from boot X but the only bootable files I've found in there are drives for all components of computer and they do nothing. So before I got the BSOD, I was casually reading a user manual to some lights I had purchased in a pdf file. I was also running a full scan in malware bytes (but I had scanned my PC the day before and it was fine.) I went to go try something with the lights and left the computer on, came back about 20 minutes later and it was asleep, which is normal obviously, but when o go to wake it up, it takes longer than usual and about 15 seconds after I wake it up I get a bluescreen. I don't recall what it all said, but the beginning said "if this is your first time seeing this restart your computer". Upon restarting I got the error reboot and boot from proper media device and that's when I began troubleshooting. I'm in the middle of opening my computer right now. This is my progress so far.

Update: messed around inside the computer for a little. I don't have any extra SATA cables so I just swapped the DVDs drive SATA cable and the hard drive SATA cable, but the hard drive still doesn't show in bios. In the missilaneous tab AHCI ports 0 and 1 are not present but AHCI port 2 reads the DVD drive ( the hard drive is connected to port 0 inside the computer). Can this just be a dead hard drive? Or would it be cheaper to go get this fixed with geeksquad?

Any friends to test that drive? Or at school/job?

Sorry I was busy today, but no my friend isn't here this week and I'd have to purchase the SATA to usb cable. Although I have looked deeper into the boot X and was able to open the registry and see the mounted devices. There are 3 listed. 1st seems to be my hard drive but it isn't recongnized, the last two are my dvd drive and boot X in that order. Any information we can pull from this?