Adding Product Listing Module to Product Info

[3rd House]

Hi,

 

I'm trying to add the product listing module to the product info page, but when I try to add it this error shows up:

 

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

[TEP STOP]

 

 

 

Here is what it looks like now:

 

http://www.yanahandbags.com/shop/index.php?cPath=21_22

 

I want the product listing module to stay in that same spot, but have the product information to the right of it. I can figure out all the styling because Im more familiar with CSS & HTML, but not so much with PHP.

 

 

Thanks in advance!!

 

—anthony

[3rd House]

Hi,

 

I'm trying to add the product listing module to the product info page, but when I try to add it this error shows up:

 

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

[TEP STOP]

 

 

 

Here is what it looks like now:

 

http://www.yanahandbags.com/shop/index.php?cPath=21_22

 

I want the product listing module to stay in that same spot, but have the product information to the right of it. I can figure out all the styling because Im more familiar with CSS & HTML, but not so much with PHP.

 

 

Thanks in advance!!

 

—anthony

 

Can anyone help?

[Kasketkarl.nu]

Have u created the mySQL file in PHPmyadmin. Table p.products_id

. If not, thats why, if seems like, that it can't find the table.

[3rd House]

Thank you for the reply, how do I create that file.

 

I'm on the page to create a mysql table and its asking me for the following:

 

Field

Type

Length/Value

Collation

Attributes

Null

Default

Extra

 

What do I put here?

[3rd House]

Here is what I have:

 

 

Error

 

SQL query:

 

CREATE TABLE `shop`.`p.products_id` (

`products_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`products_image` VARCHAR( 64 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,

`products_price` DECIMAL( 15, 4 ) NOT NULL DEFAULT '0.0000',

PRIMARY KEY ( `products_id` )

) ENGINE = MYISAM

 

MySQL said: Documentation

#1103 - Incorrect table name 'p.products_id'