Products don't appear in assigned categories

I just uploaded my website, all is well except for the fact I cannot see my products in my categories both on the website and in the admin panel. I can see my products listed in myphpadmin under the products page and the products_description page. I compared the tables of the "old" database and that of the "new" database. They each have 93 tables named the same.

Can anyone tell me what file "links" the products to the categories.

Thanks Neil

Link to the site?

http://www.pikepromo.com/zencart/index.php?main_page=index&cPath=70_69

Did you update this section in your configure,php files?

// define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', '');
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'your_username');
define('DB_SERVER_PASSWORD', 'your_password');
define('DB_DATABASE', 'your_database');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'db');

RescoCCC,

Thanks for the help

I checked those files, the only thing I can't completely confirm is the

define('DB_SERVER_PASSWORD', 'your_password');

I set up zen cart on host monster through simple scripts. The database was create automatically and I don't specifically remember creating a password. The password in my configure files is a mixture of letters and numbers that I did not create. Anyway I can go into my database and confirming the password. Or reset it so we can eliminate that as a cause.