Multi Table OSCommerce Query

Hi,

I want to present some basic data about some products that are in an OSCommerce database, tables products and products_description.

The SQL is like this:

SELECT jos_osc_products_description.language_id, jos_osc_products_description.products_name, jos_osc_products_description.products_description, jos_osc_products.products_price, jos_osc_products.products_status
FROM jos_osc_products INNER JOIN jos_osc_products_description ON jos_osc_products.products_id = jos_osc_products_description.products_id
WHERE (((jos_osc_products_description.language_id)=1) AND ((jos_osc_products.products_status)=1));

Products, description, and price where the language is English and the status is Active.

Is there a way to hack this apart and squeeze it into the ChronoConnectivity format in the component?

Thanks,
Ken

Hi Ken,

yes you can hack components/com_chronoconnectivity/chronoconnectivity.php

this is where you can find the dynamic SQL code loader code!

Cheers
Max

Thanks, Max, but that's beyond my PHP skills now. I am going to have to go with LQM or PraiseQuery, which are simpler for now.

I like the Chrono product line, and will continue to follow it, and try to work the Forms and Connectivity into my sites.

Best,
Ken

No problems, Keep checking, we have new things from time to time!😉

Regards
Max