Re: mySQL se puso DURO

Article View: chile.comp.programacion

Article #658

Back to chile.comp.programacion Previous Next

#658

From: Zarko
Date: Mon, 14 Jan 2008 03:45

15 lines
2103 bytes

Se arregla con esta estructura :-)


tep_db_query("select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, 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, p.products_tax_class_id, sp.product_id from ( " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_STAR_PRODUCT . " sp ) left join " . TABLE_SPECIALS . " s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '" . $languages_id .
"'");

Technical Details

Message-ID: <328cdc18-9836-4577-bf57-7e7703f46ea6@e4g2000hsg.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e4g2000hsg.googlegroups.com!not-for-mail

References: <83bc226c-c57b-41b3-a64d-18cc85bcba8c@s8g2000prg.googlegroups.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,e34cfe43859ae5af
X-Google-Attributes: gid1593cb,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!e4g2000hsg.googlegroups.com!not-for-mail
From: Zarko <zarko32@gmail.com>
Newsgroups: chile.comp.programacion
Subject: Re: mySQL se puso DURO
Date: Sun, 13 Jan 2008 19:45:35 -0800 (PST)
Organization: http://groups.google.com
Lines: 15
Message-ID: <328cdc18-9836-4577-bf57-7e7703f46ea6@e4g2000hsg.googlegroups.com>
References: <83bc226c-c57b-41b3-a64d-18cc85bcba8c@s8g2000prg.googlegroups.com>
NNTP-Posting-Host: 190.95.8.121
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1200282336 26291 127.0.0.1 (14 Jan 2008 03:45:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 14 Jan 2008 03:45:36 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e4g2000hsg.googlegroups.com; posting-host=190.95.8.121; 
 posting-account=xP2YdgkAAAB-czoOodEOScdKxs04zqlG
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; 
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727;
 InfoPath.2; .NET CLR 1.1.4322; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648;
 MAXTHON 2.0),gzip(gfe),gzip(gfe)

Reply to Parent Message