SearchRecent posts
The Random ToolboxDrupal 7 Setting up variables for use in a template (preprocess and process functions) Rendering Drupal 7 fields (the right way) Linux Secure Copy (scp) command Restrict Free Shipping in Magento Quickbooks Text Connection Ticket Cross-Site Request Forgery (CSRF) jQuery Events: MouseOver / MouseOut vs. MouseEnter / MouseLeave Monthly archive
|
Content Archive with Previous / Next Article Links for Any Content Type<?php $type = "news"; $foundArticle = 0; $nextNewsArticleTitle = ''; $prevNewsArticleTitle = ''; $nextNewsReleaseLink = ''; $prevNewsReleaseLink = ''; $prevNewsReleasePath = ''; $nid = ''; $nodeLink = ''; $result = db_query("SELECT type,created,title,nid FROM {node} WHERE type = '%s' ORDER BY created ASC", $type); while ($data = db_fetch_array($result)) { if($foundArticle == 1) { $nextNewsArticleTitle = $data['title']; $nid = $data['nid']; $nodeLink = 'node/'.$nid; $foundArticle++; } if($data['title'] == $node->title) { $foundArticle++; } } if($nodeLink != '') { $result = db_query("SELECT dst FROM {url_alias} WHERE src = '%s'", $nodeLink); while ($data = db_fetch_array($result)) { $nextNewsReleasePath = $data['dst']; } } $nodeLink = ''; $foundArticle = 0; $result = db_query("SELECT type,created,title,nid FROM {node} WHERE type = '%s' ORDER BY created DESC", $type); while ($data = db_fetch_array($result)) { if($foundArticle == 1) { $prevNewsArticleTitle = $data['title']; $nid = $data['nid']; $nodeLink = 'node/'.$nid; $foundArticle++; } if($data['title'] == $node->title) { $foundArticle++; } } if($nodeLink != '') { $result = db_query("SELECT dst FROM {url_alias} WHERE src = '%s'", $nodeLink); while ($data = db_fetch_array($result)) { $prevNewsReleasePath = $data['dst']; } } /* echo '<hr />NODE INFO:<hr />'; echo 'Created: ' . $node->created.'<br />'; echo 'Title: ' . $node->title.'<br />'; echo 'Next Article: ' . $nextNewsArticleTitle.'<br />'; echo 'Previous Article: ' . $prevNewsArticleTitle.'<br />'; echo 'Next Article Path: ' . $nextNewsReleasePath.'<br />'; echo 'Previous Article Path: ' . $prevNewsReleasePath.'<br />';*/ if($nextNewsArticleTitle != '') { $nextNewsReleaseLink = '<a href="/'.$nextNewsReleasePath.'">Next Release</a>'; } else { $nextNewsReleaseLink = 'Next Release'; } if($prevNewsArticleTitle != '') { $prevNewsReleaseLink = '<a href="/'.$prevNewsReleasePath.'">Previous Release</a>'; } else { $prevNewsReleaseLink = 'Previous Release'; } ?> Then, to display as an inline list . . . |