$start-$end of $total"; } else { $start = $offset+1; $view_block = "$start-$total of $total"; } $i = 2; $offset_num = 0; if($num_pages > 1) { if($page >= 2) { $page_prev = $page-1; $offset_prev = $offset-10; $prevlink = "  "; } else { $prevlink = ""; } if(($num_pages > 1) && ($page != $num_pages)) { $page_next = $page+1; $offset_next = $offset+10; $nextlink = " "; } else { $nextlink = ""; } $pages_block = "1  "; while ($i <= $num_pages) { $offset = $offset_num+=10; $pagenum = $i++; if($page == $pagenum) { $pages_block .= " $pagenum  "; } else { $pages_block .= " $pagenum  "; } } $more_pages = "$prevlink $pages_block $nextlink"; } else { $more_pages = "viewing all events"; } // end more pages if ($participants) { $participants = implode("|",$participants); } while ($row = mysql_fetch_array($result)) { $id = $row['id']; $event_title = stripslashes($row['event_title']); $start_date = $row['start_date']; $end_date = $row['end_date']; $start_time = $row['start_time']; $end_time = $row['end_time']; $venue = stripslashes($row['venue']); $location = stripslashes($row['location']); $scheduler = stripslashes($row['scheduler']); $description = stripslashes($row['description']); $contact_person = $row['contact_person']; $contact_email = $row['contact_email']; $participants = $row['participants']; $event_image = stripslashes($row['event_image']); $event_image_title = stripslashes($row['event_image_title']); $event_images_credits = stripslashes($row['event_images_credits']); $o_participants = stripslashes($row['o_participants']); //evl $db_on = mysql_connect('localhost','webuser','www123'); if ($participants != "") { $evlppl_list = explode("|",$participants); $total_evlppl = count($evlppl_list); $where_evlppl = "WHERE"; for($i=0;$i<$total_evlppl;$i++) { $where_evlppl .= " indi =\"$evlppl_list[$i]\" OR"; } $where_evlppl = substr($where_evlppl,0,-3); $evlppl_sql = "SELECT fname, lname FROM directory $where_evlppl ORDER BY lname"; $evlppl_list_new = ""; $evlppl_res = mysql_db_query("evl",$evlppl_sql) or die(mysql_error()); while($evlppl_row = mysql_fetch_array($evlppl_res)) { $evlppl_lname = $evlppl_row["lname"]; $evlppl_fname = $evlppl_row["fname"]; $evlppl_list_new .= "$evlppl_fname $evlppl_lname, "; } $evlppl_list_new = substr($evlppl_list_new,0,-2); } if ($o_participants != "" && $participants != "") { $evlppl_list_now = $evlppl_list_new .= ", $o_participants"; } else if ($participants == "") { $evlppl_list_now = $o_participants; } else { $evlppl_list_now = $evlppl_list_new; } if ($evlppl_list_now) { $evlppl_list_now = "
participants: $evlppl_list_now"; } if ($start_time && $end_time) { $times = "$start_time - $end_time"; } else { $times = "$start_time"; } $db_off = mysql_close(); if($event_image != ""){ $display_block .= "

$event_title
$evlppl_list_now
date: $start_date - $end_date
time: $times

"; //begin other display block }else{ $display_block .= "

$event_title
$evlppl_list_now
date: $start_date - $end_date
time: $times

"; } } ?> Access Grid @ the electronic visualization laboratory
home events funding research facilities collaborators
 

events

 

 

| home | events | funding | research | facilities | collaborators