//connect to ag database $db_name = "ag_db"; $table_name = "events"; $connection = @mysql_connect('localhost','ag','ag123') or die(mysql_error()); $db = @mysql_select_db($db_name, $connection) or die(mysql_error()); $today = date("Y-m-d"); $sql = "SELECT id, event_title, DATE_FORMAT(start_date, '%m/%d/%Y') as start_date, DATE_FORMAT(end_date, '%m/%d/%Y') as end_date, start_time, end_time, venue, location, scheduler, description, contact_person, contact_email, participants, event_image, event_image_title, event_image_credits, o_participants FROM $table_name WHERE start_date > \"$today\" ORDER BY DATE_FORMAT(start_date, '%Y/%m/%d') ASC LIMIT 5"; $result = @mysql_query($sql,$connection) or die(mysql_error()); 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"; } $display_block .= "
$start_date
$times
$evlppl_list_now
![]() |
|
![]() |
|||||
|
|
|||||||||||
The Access Grid (AG) is a collection of resources that enables collaboration over the grid. At EVL, this collaboration may take the form of group-to-group collaboration or participation in distributed meetings, seminars, and lectures. This project is overseen by Argonne National Laboratories and consists of many participants both nationally and internationally.
students: faculty:
|
|
|||||||||||
|
| home | events | funding | research | facilities | collaborators |