🚀 go-pugleaf

por qu� no limpias el FROM ? o dejar las tablas enlazadas con los JOIN o hacer el enlace en el WHERE, pero no mezclarlos.
A primera vista est�s haciendo un join entre sp y s con *p*.products_id = s.products_id

saludos,

"Zarko" <zarko32@gmail.com> escribi� en el mensaje news:83bc226c-c57b-41b3-a64d-18cc85bcba8c@s8g2000prg.googlegroups.com...
> Tengo una funcion (del addon "star products" en oscommerce con mysql)
> que huevea con este mensaje:
>
> 1054 - Unknown column 'p.products_id' in 'on clause'
>
> 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 products p,
> products_description pd, star_product sp left join 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 = '3'
>
>
> *******************************
>
> La funcion causante del problema es esta:
>
>
> 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 .
> "'");
>
>
> Ademas entiendo que se debe a la nueva version de php 5 se puso mas
> estricta con la sintaxis. Pero no cacho como dejar el codigo para que
> siga funcionando.