Automatic update of table, does not update web site

Hello,
I am a bit puzzled here as to what is going on! I have a website which uses
a postgresql db and has several tables of which one is product table,
category table and a category_product table.

My question /or my problem is following a previous posts I now managed to
figure out how to import the data into the product table from an existing
access database, I have also imported the categories table and also managed
to import the category_product relational table which basically has
category_id and product_id.

Now, the weird thing that is happening is that on the admin bit of the site
I am able to view all the products, but when I go to the actual site I am
unable to "drill" down through the categories in order to see the products,
UNLESS I physically click on the UPDATE button on the product edit form,
which as it should displays that the product has a relation to a category
and is highlighted.

Is this a php issue or database or both maybe;^(

Has anyone done a similar exercise before.

Here are the table structures:

CREATE TABLE "category" (
"id" integer DEFAULT nextval('"category_id_seq"'::text) NOT NULL,
"name" character varying(128),
"parent" integer,
"description" character varying(255),
"view" integer,
"keywords" text,
"featured_1" integer,
"featured_2" integer,
"visible" integer DEFAULT 1
);

CREATE TABLE "category_product" (
"category" integer,
"product" integer
);

CREATE TABLE "product" (
"id" integer DEFAULT nextval('"product_id_seq"'::text) NOT NULL,
"status" integer,
"manufacturer" integer,
"name" character varying(128),
"model" character varying(128),
"shortdesc" text,
"longdesc" text,
"smallimage" character varying(128),
"largeimage" character varying(128),
"xlargeimage" character varying(128),
"pdf" character varying(128),
"manual_url" character varying(128),
"keywords" text,
"weight" numeric(8,3),
"volumetric" numeric(8,3),
"supplier" integer,
"supplierpart" character varying(128),
"vatrate" integer
);

Thank you

zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zz/********/z/****\zzz|****\*\zz|*******|z
z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine
zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman(at)khine(dot)net
zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley
z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK
zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz
zz/******/zz\******/zz|*|zzzzzzz|*|*****|z
z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz