how to display only specific categories - warning, old ecart legacy site

old website, original designer no longer available, site has been revamped for appearance but still uses very old ecart code. it still works, so owner has been reluctant to change. while we work on that, would like to modify the existing cart to display categories in separate pages. I think this ought to be easy, but do not know enough to do so. would like to specify category by id and make different pages each showing only selected categories.

here's the code that is still working fine, displays all active categories.

http://www.miltonsbells.com/index-test1.php

and page attached.

It looks like that is controlled in the page:

include/database.php

Can I see a copy of that page?

Sure thing... thanks for looking.

I think the easiest solution is to make a copy of that page for each category that you want. Then update line 19 from:

$rsCats = $database->getCategoriesActive();

to:

$rsCats = mysql_query("SELECT * FROM products_categories WHERE CategoryID = 4", $database->connection);

and then just change the ID to whichever you want displayed on the page.

That was the line I spotted, just didn't know how to modify.

Tried your suggestion, getting an error.

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/miltons0/public_html/index-test2.php on line 576

http://www.miltonsbells.com/index-test2.php

attaching to make sure I didn't do anything dumb.

I probably guessed the CategoryID column name wrong. It might be just id or category_id.

try:
$rsCats = mysql_query("SELECT * FROM products_categories WHERE id = 8", $database->connection);

That did it! Thank you so much!

http://www.miltonsbells.com/index-test2.php

Really appreciate it!