Custom page to have the layout of products catalog

[zeppelin]

Hello everyone.

I have a custom page that I want to look EXACTLY like the
?main_page=index&cPath=whatever

the only difference is cPath won't work for me anymore (unfortunately, thus I have to to write custom php to query products table and find the products I want to include depending on a custom column in products).

So I need to show the same layout but make sure the data is differently filtered. What to do? I've been struggling with this issue and cannot seem to find one place to say how index&cPath is rendered so I can alter the SQL query and force mine there (or I'll have to do this eitherway in my custom page)

[kobra]

only difference is cPath won't work for me anymore (unfortunately

Why is this?

[zeppelin]

in the database, there are 6 categories for products. but each product has a custom column which is more detailed categories and now we want to use that one sometimes. So we're happy with the 6 categories but we wanna give the user more options if he wants to go deep (I know about cPath being able to do ABC_EFG where EFG is a subcategory of ABC [if I understand correctly]) but as the database is already different I cannot do that either.

Thus I need a method to show the same layout with just different data (I know the SQL I want to write)

[kobra]

Load your page and get the url end

Such as

/index.php?main_page=my_page

Then make a folder in /your template/my_page/

Put a custom copy of tpl_main_page.php in it

Customize this to your needs

[zeppelin]

kobra thanks for helping man.
Since I 've read the wiki on how to create a new page, you're saying the product listing layout is in tpl_main_page.php page and all I have to do is what then? I've looked into the page (can be found also http://phpxref.com/xref/zencart/incl...hp.source.html) and nowhere does it include the layout I want nor the sql query to change. It just goes on to include other tpl_ files and I lose it from there

[kobra]

you're saying the product listing layout is in tpl_main_page.php page

Actually not - - Default Product layout in tpl_product_info_display.php but I am guessing you are not using it as there is only one and you state you have 6 layouts

[zeppelin]

koba, thanks again for helping me and sorry to confuse you.
I don't have 6 layouts. I have 6 cPaths and I cannot add more there.
I have a lot of products belonging to one of those 6 cpaths. I also have a special column for those products. I want to use that column to feed the same page or another page I don't mind as long as it keeps the same layout and form as the one with cPath.

This is what I want to do, I hope you can you help me. (I'm a rookie in zencart, but not to programming)

so what I want is ?main_page=index&cPath=WHATEVER&myCOL=ABC or even better ?main_page=index&myCol=ABC and this should show all those products that have myCOL=ABC (myCol is an extra col I've added in the products table) or at worse ?main_page=mypage?myCol=ABC (but mypage show use the layout of index?myCol and where is that and how to do that)

[kobra]

I don't have 6 layouts. I have 6 cPaths and I cannot add more there.
I have a lot of products belonging to one of those 6 cpaths.

I also have a special column for those products.

From your explanation, I do not understand what it is you are attempting.

[dbltoe]

This is one of those where we REALLY need some of the information from the posting tips!

Can't imagine a limit on cpath

[zeppelin]

ok I'll try to rephrase:
products table:

pid cpath specialCol
1    1234   155
2    1234   156
3    1235   155
4    1234   188

I want to show a page asking products where specialCol is 155 and this page ideally should have the looks like the one shown if I do cPath=1234