Totally Zenned
- Join Date:
- Oct 2006
- Location:
- Italy
- Posts:
- 636
- Plugin Contributions:
- 0
special end date on product info
I've add this on tpl_product_info_display.php:
<?php
$products_end_query = $db->Execute ("select expires_date from " . TABLE_SPECIALS . " where products_id = ". $_GET['products_id'] ." ");
$products_end = $db->Execute($products_end_query);
if ($products_end['expires_date'] > date('Y-m-d H:i:s')) {
?>
<tr>
<td align="center" class="main"><?php echo sprintf(TEXT_DATE_END, zen_date_long($products_end['expires_date'])); ?></td>
</tr>
<?php
} ?>
to have specials end date on product info; but I've this error:
1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Object' at line 1
in:
[Object]
Why?
Any suggestion is appreciate.