Are you able to mount other optical media successfully? If you put the Photoshop CS6 DVD in another Macintosh is it able to be read properly? If you can read other discs fine and the disc won't mount on another Mac then it is likely a problem with the DVD.

If the DVD can be mounted on another Macintosh then it is probably an issue with the optical drive on your Macintosh.