Pricelist contribution

[PSX Norge]

Use the contib http://www.oscommerce.com/community/contributions,1705/

And are very satisfied with that, but. Always a but with everything. Can I make it show all products, even those who are not in stock? (stock=0)

 

Any help is appriciatet

[PSX Norge]

The thing I'm looking for is a complete pricelist, not in PDF

[PSX Norge]

Solved the problem myself :P

 

In line 81 I changed the line from

$products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_quantity <>0".$query." and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);

 

To

$products_price_query = tep_db_query("select products_description.products_name, products.products_quantity, products.products_price, products.products_model, products_to_categories.products_id, products_to_categories.categories_id FROM products, products_description, products_to_categories where products.products_id = products_description.products_id and products.products_id = products_to_categories.products_id and products_to_categories.categories_id = ".$id_group);

 

Removed a part in the midle that said:

and products.products_quantity <>0".$query."

 

 

I'm beginning to get a hang on the php now.... :thumbsup: