StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5105364
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-02-24T13:36:27.817
FavoriteCount
0
LastActivityDate
2011-02-26T21:08:38.523
LastEditDate
2011-02-26T21:08:38.523
LastEditorUserId
201316
OwnerUserId
201316
ParentId
5058496
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
To get linked titles you need to use the <code>l()</code> function. looking at the code you provided, I am not entirely sure how you are getting any results since you save the titles in <code>$resultArray</code> but use <code>$rows</code> when rendering the table. Unless, $rows is specified somewhere else, <code>$resultarray[$nodeobj->nid] = $nodeobj->title;</code> should become <code>$rows[$nodeobj->nid] = $nodeobj->title;</code> To make it match your table header, you need to add another 'cell' for the number column <pre><code>$rows[$nodeobj->nid] = array( $count++, l($nodeobj->title, 'node/'.$nodeobj->nid) ); </code></pre> To provide the excerpt too, you need to join the node_revisions table and get either the body or teaser column, then add it to your rows like this: <pre><code>$rows[$nodeobj->nid] = array( $count++, '<h2>'. l($nodeobj->title, 'node/'.$nodeobj->nid) .'</h2>'. $nodeobj->teaser ); </code></pre> assuming you get the teaser. EDIT the previous answer still holds. You can also simplify the code a bit by processing $rows straight in the $noderesults loop. function query_results($searchstring, $datefrom) { $tidresult = db_query("SELECT tid FROM {term_data} WHERE LOWER(name) = '%s'", strtolower($searchstring)); <pre><code> $rows = array(); $count = 0; while ($obj = db_fetch_object($tidresult)) { $tid = $obj->tid; $noderesults = db_query("SELECT n.nid, n.title FROM {node} n " ."INNER JOIN {term_node} tn ON tn.nid = n.nid " ."WHERE tn.tid='%s'", $tid); while ($nodeobj = db_fetch_object($noderesults)) { $rows[] = array( ++$count, l($nodeobj->title, 'node/'. $nodeobj->title) ); } } $header = array( array('data' => 'Nr.'), array('data' => 'Name'), ); $output = theme('table', $header, $rows); print theme("page", $output); } </code></pre> -OR- move it all in one query (note: I did not get a chance to test this, but I usually get it right the first time): <pre><code>function query_results($searchstring, $datefrom) { $rows = array(); $count = 0; $results = db_query("SELECT n.nid, n.title FROM {node} n INNER JOIN {term_node} tn ON tn.nid = n.nid WHERE tn.tid IN (SELECT tid FROM {term_data} WHERE LOWER(name) = '%s')", strtolower($searchstring)); while ($nodeobj = db_fetch_object($results)) { $rows[] = array( ++$count, l($nodeobj->title, 'node/'. $nodeobj->title) ); } $header = array( array('data' => 'Nr.'), array('data' => 'Name'), ); $output = theme('table', $header, $rows); print theme("page", $output); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to link custom results in Drupal
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USzerolab
UserOwnerUserId
1. USzerolab
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to link custom results in Drupal
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COHi thanks for answering , I put the missing code. I pasted an older version of my code so the complete one is up there now .
 singulars
 PostPostId
 PO
 UserUserId
 US2thecore
2. COedited my answer with more code..
 singulars
 PostPostId
 PO
 UserUserId
 USzerolab

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.