Forums / General Questions / special end date on product info

special end date on product info

Locked

Started by 100asa on 20 Oct 2006, 1:49 PM · Views: 1,188

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
20 Oct 2006, 1:49 PM
#1
100asa avatar

100asa

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.

21 Oct 2006, 12:52 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: special end date on product info

The fields are referenced from select statements as:

$products_end->fields['expires_date']

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Oct 2006, 5:25 AM
#3
100asa avatar

100asa

Totally Zenned

Join Date:
Oct 2006
Location:
Italy
Posts:
636
Plugin Contributions:
0

Re: special end date on product info

Sorry, I don't undertsand

21 Oct 2006, 2:33 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: special end date on product info

You are referencing the field as:

$products_end['expires_date']

You need to reference it as:

$products_end->fields['expires_date']

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!