Trying to build an examination timetable - Views, CCK

One approach would be to define an appropriate taxonomy:

Semesters

• 2006-2007
  • semester 1
  • semester2
• 2007-2008
  • semester 1
  • semester2

Then each of your timetabled classes get tagged with the appropriate semester.

Then you can create a dropdown list that will take the user to the appropriate timetimble.

I can't find the post that explains this, but here is the code for the dopdownlists from my own site:

<?php
echo '<form name="jump'.$vocabulary_id.'"><select name="menu'.$vocabulary_id.'">';
echo '<option value="">--Select a semester--</option>';
echo '<option value="">--------------------</option>';
foreach($rows as $v1){
echo "<option value='/".$v1[0]."'>".$v1[1]."</option>";}
echo '</select><input type="button" onClick="location=document.jump'.$vocabulary_id.'.menu'.$vocabulary_id.'.options[document.jump'.$vocabulary_id.'.menu'.$vocabulary_id.'.selectedIndex].value;" value="GO" /></form>';
?>

The sql required to generate the dopdown list would be something like: this (but I use flexinodes, you'll need to determine the correct SQL for cck).

<?php
$vocabulary_id = "4"; //or whatever the id is for your higest level semester vocabulary
$tid= taxonomy_get_children($vocabulary_id ); //this will get your valid years

$tid_list = array();
foreach ($tid as $next_tid) {
    $tid_list[] = $next_tid;
    $children = taxonomy_get_children($next_tid);
    foreach ( $children as $child_tid ) {
        $tid_list[] = $child_tid->tid;
    }
}
$tid_set = implode(', ', $tid_list);

 $select = "SELECT DISTINCT(tn.tid), td.name ";

  $count = "SELECT COUNT(DISTINCT(n.nid))";

  $from_where = " FROM {node} n INNER JOIN {term_node} tn USING(nid) INNER JOIN {term_data} td USING(tid) WHERE n.status = 1 AND n.type='Flexinode-1' AND tn.tid in ($tid_set)";

  $orderby = " ORDER BY td.name";

  $sql = $select . $from_where . $orderby;

  $rows = array();
  $nodes = db_query($sql);

while ($node = db_fetch_object($nodes)) {
    $row = array('node/'.$node->tid, $node->name);
    $rows[] = $row;
  }

?>

I hope this helps, or gives you a place to start researching further.

Cheers,

--
tys

BLUE MOUNTAINS health & harmony
www.health-harmony.com.au

building an alternative health & spirituality community in the Blue Mountains