Malthusian Prophecies

Image via CrunchBase

So Drupal 7 dynamic queries…love them, and hate them.

I just noticed that if you set execute the query, then use the results in a foreach you can’t reuse that result set in another foreach?!  So if you’re looking to make a menu for dynamic content on the page (like a JQuery UI tab switcher dealy…that’s what I’m doing) you evidently can’t use the same query to populate both the ul and the content of each div?  Lame.

Related articles

• Guy Van Sanden: Upgrading to Drupal 7, not always easy (nocturn.vsbnet.be)

….The more I LOVE! it. 

The database abstraction layer is truly fantastic!  It already was in Drupal 7 but they’ve definately made it more dynamic in 7. Love it! Check out this example where I’m creating a fairly straightforward, but not simple, query. In this query I’m pulling from one table and joining 2 more with all kinds of conditions and ordering logic. I can add or take away very quick without having to mine through a monster query!

$example_prepare = db_select('example', 'a');
$example_prepare->leftJoin('example_one', 'b', 'a.nid = b.nid');
$example_prepare->leftJoin('example_two', 'c', 'c.nid = a.nid');
$example_prepare->fields('a')
		->fields('b', array('title','created'))
		->fields('c',array('blahblah'))
	 	->condition('a.created',$dateRange['value'],'>=')
	 	->condition('a.created',$dateRange['value'],'<=')
	  	->orderBy('a.created', 'ASC')
	  	->orderBy('c.blahblah')
	  	->orderBy('b.title');
		  	
$example = $example_prepare->execute();

Related articles

• The best part of my job: Drupal Community Events 2011 Roundup (acquia.com)
• Drupal or Joomla? (josephgeorge.wordpress.com)