I have a Canon Digital IXUS 970 IS camera, ive lost the CD that came with it so i cannot install it. is there a website i can download it from?

The IXUS 970 is called the SD890 in some parts of the world. You can download the software for the SD890 from
http://www.usa.canon.com/cusa/support/consumer/digital_cameras/powershot_sd_series/powershot_sd890_is#DriversAndSoftware

You might want to consider NOT connecting your camera to your computer. The best way to download pictures from your camera to your computer involves removing the memory card from the camera and plugging it into a card reader (either built-in to the computer or connected via USB or FireWire). This is likely to be faster than connecting the camera to the computer, and won't run down your camera's batteries.

Once the card is plugged in, it will appear to your computer as a removable drive. You can use the operating system's drag&drop facility to copy pictures from the card to the computer's hard drive, the same way you copy any other files. Or you can use any photo cataloging program.