X-Cart forums

[charlesw]

The XC-SEO category fix is awesome and saves time on xml updates

I noticed that product links appear for every category they are assigned to, i.e. if a product is assigned to two categories then there will be two identical links in the xml output twice

Any ideas on how to fix this in the php script, i.e. generate only one link per product irrespective of how many categories it is assigned to?

Thanks, Charles

[carlisleglass]

Add

GROUP BY p.productid

after

p.forsale="Y"

to make it look like

p.forsale="Y" GROUP BY p.productid

Basically put it where the LIMIT BY was.

i.e.

$query = '
        SELECT
                p.productid,
                p.product,
                pc.categoryid
        FROM
                ' . $sql_tbl['products'] . ' p
                INNER JOIN ' . $sql_tbl['products_categories'] . ' pc ON (p.productid = pc.productid)
        WHERE
                p.forsale="Y" GROUP BY p.productid
                ';