xtknight, the Audigy line-in jack is analog only. Coaxial cable as used for VCR composite can be used between the analog output of your device (tuner?) and line-in but will not really increase the quality (although theoretically better shielding could reduce the chance of quality loss). It would still require two cables into the adapter.
But as I understand, what you really want is digital audio input, which since the Audigy lacks a physical jack, requires connecting to the Audigy board either directly or via a plate, particularly if optical. As said, optical requires added electronics and there is no general advantage except that it avoids an electrical link between devices so there is no chance of a ground loop, which is why the fellow at twam.info wanted to use it for output.
In any case, that guide and the one linked to at hificomputers.net has all the info on how to hook up common mobo plate adapters to the Audigy for any combination of coaxial and optical I/O.