enlarge product image at product listing

[leinad96]

Hi coders & fellow friends,

 

I kind of need help here, I am trying to add in a 'click to enlarge' link at the product listing page. But I am not well versed in PHP. I manage to find a contribution (Enlarge Picture Button In Product List) but its cant seems to work, I am wondering if any one of you can kindly guide me out? I would appreicates it ! Thanks in advance... :D

[leinad96]

bump.

[davidinottawa]

Hi coders & fellow friends,

 

I kind of need help here, I am trying to add in a 'click to enlarge' link at the product listing page. But I am not well versed in PHP. I manage to find a contribution (Enlarge Picture Button In Product List) but its cant seems to work, I am wondering if any one of you can kindly guide me out? I would appreicates it ! Thanks in advance... :D

 

what doesn't work about it ?

url ?

[leinad96]

I am trying to set this contribution in. I managed to follow the readme file and does everything it says but I got this problem in the end.

 

Contribution link: http://www.oscommerce.com/community/contributions,4110

 

Error code prompt: 1054 - Unknown column 'p.products_enlarge_icon' in 'field list'

 

select p.products_enlarge_icon, p.products_image, pd.products_name, p.products_quantity, 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 = '71' order by pd.products_name limit 0, 20

 

[TEP STOP]

 

 

Anyone have any idea on how to troubleshoot this problem?

[davidinottawa]

I am trying to set this contribution in. I managed to follow the readme file and does everything it says but I got this problem in the end.

 

Contribution link: http://www.oscommerce.com/community/contributions,4110

 

Error code prompt: 1054 - Unknown column 'p.products_enlarge_icon' in 'field list'

 

select p.products_enlarge_icon, p.products_image, pd.products_name, p.products_quantity, 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 = '71' order by pd.products_name limit 0, 20

 

[TEP STOP]

Anyone have any idea on how to troubleshoot this problem?

 

Well - the error say you have a missing column : p.products_enlarge_icon

Were you supposed to add the products_enlarge_icon column to the products table ?

 

if so - you need to add this column using thephpMyAdmin utility provided to you by your web host.

 

david

[leinad96]

hi david thanks for your reply again, i appreciate your help so far , I will try to

follow up on that :)

[leinad96]

YES. Managed to do it finally! Thanks to you David!! really appreciate your help alot!