Your branding and image online can quickly be eroded and damaged if your website is suddenly harbouring malicious code. Code like this could be inserted many ways, from an weakness in the code your website is running (SQL injection, XSS cross side scripting) or via a breech in your server. These types of site attacks can knock (no pun intended) your website out of the index and reduce your traffic and potential sales to zero.
Today I was doing a search for skiing ireland on google, when I noticed that one of the websites listed was flagged by google. The reason for the flagging ? The message from google was:
Warning – visiting this web site may harm your computer!
Here is a screenshot what google displayed for KnockAirport.com

Suggestions:* Return to the previous page and pick another result.
* Try another search to find what you’re looking for.Or you can continue to http://www.knockairport.com/news.asp?dbtype=news&id=51 at your own risk. For detailed information about the problems we found, visit Google’s Safe Browsing diagnostic page for this site.
For more information about how to protect yourself from harmful software online, you can visit StopBadware.org.
If you are the owner of this web site, you can request a review of your site using Google’s Webmaster Tools. More information about the review process is available in Google’s Webmaster Help Center.