Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

a problem i cannot debug


actionjackson

Recommended Posts

Posted

hi,

 

i am new to oscommerce and have spent some time now trying to get banners to work. banner manager in admin shows impression count going up, but no banners showing. text banner shows just fine. I have assigned group to banner. Now for the cruncher - when i comment out the code, i get this in the html output<!---<td align="center" valign="middle"><a href="http://www.prstach.org/catalog2_gr_border/redirect.php?action=banner&goto=2" target="_blank"><img src="images/banners/oscommerce.gif" border="0" alt="oscomm" title=" oscomm " width="468" height="50"></a></td>--> - looks correcr. however when i uncomment the code, the html output is <td align="center" valign="middle"><a href="http://www.prstach.org/catalog2_gr_border/redirect.php?action=banner&goto=1" target="_blank"></a></td> clearly when i uncomment, the banner image is not called.

 

 

 

 

DEBUG QUERY looks good -

 

[5] => select banners_id, date_scheduled from banners where date_scheduled != ''

[6] => select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

[10] => select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'

[11] => select count(*) as count from banners_history where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')

[12] => update banners_history set banners_shown = banners_shown + 1 where banners_id = '2' and date_format(banners_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d')

 

 

any ideas, i am at an absolute loss ????????

Archived

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

×
×
  • Create New...