Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Next revisionBoth sides next revision
drupal_notes [2008-03-24 22:11] – 81.188.78.24drupal_notes [2008-03-25 00:22] – 81.188.78.24
Line 103: Line 103:
     * node_example.module: http://api.drupal.org/api/file/developer/examples/node_example.module/5/source     * node_example.module: http://api.drupal.org/api/file/developer/examples/node_example.module/5/source
     * node_example.install: http://api.drupal.org/api/file/developer/examples/node_example.install/5/source     * node_example.install: http://api.drupal.org/api/file/developer/examples/node_example.install/5/source
 +
 +
  
  
Line 132: Line 134:
     * yes, /gallery/tid/XX where XX is the id of the tag.     * yes, /gallery/tid/XX where XX is the id of the tag.
     * but since galleries can't really be included in anything else (views, panels etc) they are kind of useless.     * but since galleries can't really be included in anything else (views, panels etc) they are kind of useless.
 +  * how would i do a view-like taxonomy query in mysql? (doesn't the devel module tell you this stuff?)
 +    * <code>select * from node join term_node where node.nid=term_node.nid and tid=63;</code>
 +    * <code>select * from node join term_node, term_data where node.nid=term_node.nid and term_node.tid=term_data.tid and term_data.name="xmedk";</code>
 +    * nicer: <code>select * from node join term_node on  node.nid=term_node.nid join  term_data on term_node.tid=term_data.tid where term_data.name="xmedk";</code>
 +
  • drupal_notes.txt
  • Last modified: 2008-03-31 17:24
  • by 81.188.78.24