Probably a dry joint, easily fixed with a soldering iron.
Surely the LCD TV will have a button on it (or on the remote) to select an input?
Just connect a VGA cable and select VGA.
If your PC only has DVI video you can get a DVI to HDMI cable, but VGA is probably easier if available.