I'm a new comer to wordpress...

I've downloaded complete wordpress project from the website via ftp then go ahead and take backup copy from the online database. I've place the database during my local machine in mysql. with the aid of phpmyadmin i've modified the hyperlinks in wordpress_publish of site url and residential and set my complete backup of website on local webserver. all over the place link is working correctly but on first page on a single link it shows me this content is related to online. so when i click the link it get forwarded to my website. and never working from offline. How do i change it out to operate on my small local system.

you have to look into the wordpress DB tables for that links, they still consists of the internet Web addresses.

Look into the 'wp_posts' table for that 'guid' area.