<div dir="ltr">this is code <br><br>output is blank page<br><br><?php<br><br><br>function sample_menu(){<br> <br> $content[] = array(<br> 'title' => t('Taxonomy'),<br> 'path' => 'sample',<br>
'callback' => 'display',<br> 'access' => user_access('authenticated user')<br> );<br> return $content;<br>}<br><br>function display(){<br><br><br>$vid = 3;<br>
$sql = db_rewrite_sql("SELECT n.nid, d.tid, <a href="http://d.name">d.name</a>, n.title, n.created<br>FROM {term_data} d<br>INNER JOIN {term_node} t on t.tid = d.tid<br>LEFT JOIN {node} n on t.nid = n.nid<br>WHERE d.vid = %d<br>
AND n.type = 'page'<br>ORDER BY <a href="http://d.name">d.name</a> ASC, n.created DESC",<br>'n', 'nid');<br><br>// Eliminate the DISTINCT that db_rewrite_sql() inserted.<br>$sql = str_replace('DISTINCT(n.nid)', 'n.nid', $sql);<br>
$result = db_query($sql, $vid);<br>echo "This is result".$result."<br>";<br>$last = '';<br>echo $last."<br>";<br>while ($data = db_fetch_object($result)) { echo "hi this data".$data;<br>
$month = format_date($data->created, 'custom', 'm/Y'); // e.g., 3/2007<br>echo $month;<br>if ($last == $data->name) {<br>$output .= '<li>' . l($data->title, "node/$data->nid") . " ($month)</li>";<br>
}<br>else {<br>if ($last) {<br>$output .= '</ul>';<br>}<br>$last = $data->name;<br>$output .= '<h3>' . check_plain($data->name) . '</h3>';<br>$output .= '<ul>';<br>
$output .= '<li>' . l($data->title, "node/$data->nid") . " ($month)</li>";<br>}<br>}<br>$output .= '</ul>';<br>return $output;<br>}<br><br><br><br></div>