dayOff Posted November 24, 2006 Posted November 24, 2006 Hi I have forty products, each of which have the same thirty or so sub categories. Is there any reason why I can't run a series of SQL statements automatically to populate the categories and categories_description tables? Are there any relationships I need to know about, or anything else? Obviously I've spotted the parent field, there doesn't seem to be anything more complicated than that. Cheers J ---------------------------- John Allsopp http://www.johnallsopp.co.uk/
driftwood Posted November 24, 2006 Posted November 24, 2006 Hi I have forty products, each of which have the same thirty or so sub categories. Is there any reason why I can't run a series of SQL statements automatically to populate the categories and categories_description tables? Are there any relationships I need to know about, or anything else? Obviously I've spotted the parent field, there doesn't seem to be anything more complicated than that. Cheers J I had the same thing, if I remember rightly I just did one and exported it with EPOP then added the rest and imported. ----------------------------------------------------------------------------- OSC user for years and no coder, so I've earned my stripes. Feel free to private message me.
dayOff Posted December 1, 2006 Author Posted December 1, 2006 I had the same thing, if I remember rightly I just did one and exported it with EPOP then added the rest and imported. Dunno what EPOP is, but I wrote a PHP script to populate the database and it seems to be working OK. Cheers J ---------------------------- John Allsopp http://www.johnallsopp.co.uk/
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.