how do i change something in index.php

[ICrazyBoy]

On index.php and in left menu. When i select list/menu Manufacturers after select show detail .

 

code include file

 

include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

 

now Index.php show "New Products For.."

 

code include file

 

include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);

 

I want to show Manufacturers only ( include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); )

 

I try to change

 

include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);

 

to

 

include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

 

have error.

 

 

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

 

How to change this. Help me plz

[Guest]

Maybe if you send your url we can understand you better.

 

On index.php and in left menu. When i select list/menu Manufacturers after select show detail .

 

code include file

 

include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

 

now Index.php show "New Products For.."

 

code include file

 

include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);

 

I want to show Manufacturers only ( include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); )

 

I try to change

 

include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);

 

to

 

include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

 

have error.

 

 

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

 

How to change this. Help me plz

[sharma.atul85]

please clarify what exactly you want ..

[Nullachtfuffzehn]

The error is caused by an incomplete SQL statement. Apparently the rest of the statement has been cut somehow.

[ICrazyBoy]

now when go to website index page (index.php) show New Products For (month) follow image.

 

image1

 

and when click Manufacturers(have one catagory) in left menu follow image.

 

image2

 

after select show this

 

image3

 

 

I want to change

 

when go to website i want to show follow image3 (not show image1)

 

 

How do i change.

 

 

Thank You.

Best Regards,

ICrazyBoy

[ICrazyBoy]

Help me please.....

 

 

Thank You