Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Location
    Italy
    Posts
    634
    Plugin Contributions
    0

    Default special end date on product info

    I've add this on tpl_product_info_display.php:
    PHP Code:
    <?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_ENDzen_date_long($products_end['expires_date'])); ?></td> 
          </tr> 
                <?php 

        
    ?>
    to have specials end date on product info; but I've this error:
    Code:
    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.

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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!

  3. #3
    Join Date
    Oct 2006
    Location
    Italy
    Posts
    634
    Plugin Contributions
    0

    Default Re: special end date on product info

    Sorry, I don't undertsand

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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!

 

 

Similar Threads

  1. v154 Special product expiry date
    By Cenkki in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 23 Feb 2015, 03:28 PM
  2. start and end date of special products
    By myworld20091 in forum Setting Up Specials and SaleMaker
    Replies: 2
    Last Post: 29 Nov 2008, 08:02 PM
  3. Special's End Date
    By inthecomputer in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 18 Sep 2008, 06:06 PM
  4. special start and end date
    By 100asa in forum General Questions
    Replies: 2
    Last Post: 25 Oct 2006, 12:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg