Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Listing in Columns


Misteraven

Recommended Posts

I really love this contribution... (Product Listing in Columns)

 

http://www.oscommerce.com/community/contri...uct_listing_col

 

Unfortunately, I can't seem to get it working with 2.2 MS2, though I did add some other contributions as well, so it's not a default install. However, it's not so heavily modified that it should suddenly stop working. Only other contribution I added that's even relevant is 'Sold Out' (http://www.oscommerce.com/community/contributions,112/category,3/search,product_listing_col).

 

Anyone have any suggestions?

 

Thanks.

Link to comment
Share on other sites

here's the error I keep getting with that contribution...

 

1064 - You have an error in your SQL syntax near 'select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p' at line 1

 

select count(select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = \'1\' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'1\' and p2c.categories_id = \'28\' order by pd.products_name) as total

Link to comment
Share on other sites

I have the same problem but maye nobody know how to fix it. The authors of osCommerce too as i see.

 

 

Last night I found one contribution named " conventional style listing....something...". thread in Tips&Tricks I remember.... A lot changes to me....I'm new here so didn't try....

Link to comment
Share on other sites

  • 1 month later...

i was woundering if any one can tell me where the html for that listing located which wraps around the listing where we have

==== Product Name+ Price Buy Now ====

i need to modify html so i can get the needed look, here is link to show you what i mean, look at the side colums with boxes and look at the middle table with the listing,

http://www.meadetelescopes.com/store/index.php/cPath/2_20

i need to modify that table ( HTML wise, cause none of the things i need to change are left in styles. )

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...