Tried the recommendation on several threads. Here is the issue. The admin is working and updated the new DB fine. When you view the site from the frontend the product data, images, and links all point to the original site.
I Began by creating a new DB and importing a back up of the other Magento DB. The DB has a different name, the login and pw are different as well.
I modified the secure and unsecure URLs in the core_config_data table. I then installed a fresh copy of Magento (same version as my old site ver. 1.7.0.2).
I emptied the log tables which contained the old URL as well.
I looked at the local.xml file which had the correct settings.
Please keep in mind I have not added any source files from the old site. The olny thing that is from the old site is the DB.
Any other advice would be huge! Thanks in advance.