List of campaigns and regions with images or linked nodes
Date:
Thursday, October 11, 2007
$result = db_query("SELECT nid FROM node WHERE type = 'campaign' OR type = 'region' ORDER BY title");
print '';
while($nid = db_fetch_object($result)) {
$node = node_load($nid->nid);
print '
';
?>
' . l($node->title, 'node/' . $node->nid) . ' | '; print '' . $node->type . ' | '; print '' . $node->language . ' | '; if($node->field_signature_image_ref[0]['nid']) { print '' . l('view image','node/' . $node->field_signature_image_ref[0]['nid'],NULL,'size=_original') . ' | '; } else { print ''; } if($node->field_main_image[0]['filename']) { print ' | filename: ' . $node->field_main_image[0]['filename'] .' credit: ' . $node->field_main_image[0]['credit'] .' caption: ' . $node->field_main_image[0]['caption'] .' | ';
}
else {
print 'none | '; } print '