Check out DrupalEasy around the web:
DrupalEasy is the collective expertise of Ryan Price and Michael Anello, who joined forces to provide training and consulting services worldwide. Read all about them and what they can do.
Drupal is a free, super-powerful content management system for sites that require information posting and collection, including blogs, forums, videos, photos, and databases of information. We think it is the best platform available. Here's why...
More and more savvy organizations are going with Drupal for content management, and its no mystery why. It’s free, flexible, and easy to maintain for small or large volume sites. Learn more...
When using taxonomy to group nodes on your Drupal site, you find a need to apply another taxonomy term to all of those nodes (possibly from a different vocabulary) there is nothing that is going to be shorter and sweeter than some quick SQL-fu.
Here is a quick MySQL snippet to do just that:
create temporary table my_temp_table as
select * from term_node where tid = XXX;
insert into term_node (nid,tid) select nid, 'YYY' as tid from my_temp_table
Just replace XXX with the TID of the term that is already grouping your content, and replace YYY with the TID of the term you want to apply to all of them. You can comment out the first and last lines to use the select statement to check to make sure that these are the nodes you're after before committing all of the insert statements to the Database.
Enjoy!
does anyone know a way to
does anyone know a way to build a related nodes link block not based on taxonomy, but on similarity in the node title?
Cant this be simplified
Cant this be simplified to...
INSERT INTO term_node (nid,tid) SELECT nid, Y FROM term_node WHERE tid = X;
Pingback
[...] Go to the author’s original blog: Relate all nodes from one taxonomy to another with MySQL [...]