Somebody explain, If the BIOS isn't seeing the drive and after hitting F1 to continue how will there be a drive to run fdisk on???
Can you hear the drive startin up at all?
If not, the controller on the hard drive or mother board isn't working or there's a loose/bad power connection. If the ribbon cable was bad you'd still hear the drive spinning up.
Since you know it works, disconnect the ribbon cable for the cdroms and use it to test the hard drive. Do the same with the power connector. If it still doesn't come up, try the hard drive on the second IDE connection on the mother board to see if the BIOS can find it there. If you can get the drive to come up that way then at least the drive's OK. If it's a western digital drive and you've disconnected another drive or cdrom from it you must change the jumper setting on the drive from "master w/slave to single". Most other drives only have "master/single, slave and cable select".
Ok, the damn drive still doesn't come up. Remove the drive, hold it tightly in your hand palm up, give it a couple of good swift turns like turning a door knob. Make sure to keep the drive level.
You may even hear it start spinning. Reinstall and see if it comes up. This sounds crazy I'm sure but I've had this work plenty of times when drive's head become magnetically stuck to the platters this is simular to a crash but not quite the same, its know as stiction.
Good luck