Hi,
when you look at the sql-phrase, you can see the there is JOIN between
oxcategorie, oxobject2attribute (articles<->attributes) and oxcategory
attribute.
So it shows only attributes conntected to articles AND categories.
I guess you have to write your own query Like:
SELECT *. oxattribute From oxattribute JOIN oxcategory2attribute
ON oxattribute.OXID = oxcategory2attribute.OXATTRID
WHERE oxcategory2attribute.OXOBJECTID =$sChosenArtCat
ORDER BY OXSORT
You should test it with a real oxcategory.oxid in phpmyadmin (my
misspellings)
Regards
HJue
--
Hans Jürgen Fricke
Hermann-Enters-Str. 1
42285 Wuppertal
Fon 0172 4217539
email: [email protected]
_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
