"); $username="iwtsgnf_bobcaspe"; $password="tet8Bimf"; $database="iwtsgnf_"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "SELECT * FROM employees WHERE `employee_id`=$employee_id"; $result = mysql_query($query); $user_first_name = mysql_result($result,0,"first_name"); $user_last_name = mysql_result($result,0,"last_name"); $c1=0; $c2=0; $c3=0; if (($companies & 1)==1) $c1 = 1; if (($companies & 2)==2) $c2 = 2; if (($companies & 4)==4) $c3 = 4; $query = "SELECT employees.first_name, employees.last_name, cda_news.date, cda_news.event, cda_news.headline, cda_news.company FROM `cda_news`, `employees` WHERE ((employees.employee_id=cda_news.employee_id) AND ( (cda_news.company=7) OR (cda_news.company=$c1) OR (cda_news.company=$c2) OR (cda_news.company=$c3) ) ) ORDER BY cda_news.date DESC"; $result = mysql_query($query); $num = mysql_numrows($result); $numpages = intval(($num+4)/5); mysql_close(); if($page=="") $page=1; if($R1=="earlier") { $page=$page+1; if($page>$numpages) $page=1; } if($R1=="later") { $page=$page-1; if ($page==0) $page=1; } if($R1=="") $R1="earlier"; ?>
 

Alumni Forum

Page $page of $numpages
"; $i=($page-1)*5; $last = $i + 5; if ($last>$num) $last=$num; while ($i<$last) { $date = mysql_result($result, $i, "cda_news.date"); $first_name = mysql_result($result, $i, "employees.first_name"); $last_name = mysql_result($result, $i, "employees.last_name"); $event = mysql_result($result, $i, "cda_news.event"); $headline = mysql_result($result, $i, "cda_news.headline"); $company = mysql_result($result, $i, "cda_news.company"); if ($company==1) $company_name="CDA"; if ($company==2) $company_name="Leaf"; if ($company==4) $company_name="SVI"; if ($company==7) $company_name="All"; $event = wordwrap($event, 80, "
\n"); echo "

Date - $date         $company_name
Submitted by: $first_name $last_name
$headline

$event


"; $i=$i+1; } ?>

Welcome

if you're not please logout

Show News Stories for:

 

© Copyright - The Caspe Group LLC 2008