| |
Alumni Employees - Welcome echo "$first_name" ?>
if you're not echo "$first_name" ?> please logout
$query = "SELECT * FROM employees WHERE 1";
$result = mysql_query($query);
$num_employees = mysql_numrows($result);
$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))
ORDER BY cda_news.date DESC";
$result = mysql_query($query);
$date = mysql_result($result, 0, "cda_news.date");
$first_name = mysql_result($result, 0, "employees.first_name");
$last_name = mysql_result($result, 0, "employees.last_name");
$event = mysql_result($result, 0, "cda_news.event");
$headline = mysql_result($result, 0, "cda_news.headline");
$company = mysql_result($result, 0, "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");
$query = "SELECT * FROM epix WHERE 1";
$result = mysql_query($query);
$num_pix = mysql_numrows($result);
$last = $num_pix-1;
$pic_id=mysql_result($result,$last,'pic_id');
$caption=mysql_result($result,$last,'caption');
$year=mysql_result($result,$last,'year');
$filename="uploads/I$pic_id.jpg";
mysql_close();
?>
These links are for Former Employees of CDA, Leaf Systems and
Sound Vision. They are intended to facilitate intra-community
communications and activities among the friends that have formed through these
companies.
There are currently echo "$num_employees"; ?> members signed up.
Members are encouraged to post both News and Photos.
Share your latest items with former friends and co-workers.
|
The latest NEWS submitted
Date - echo "$date" ?>
Submitted by - echo "$first_name $last_name" ?>
Headline - echo "$headline" ?>
echo "$event" ?>
The latest Photo submitted
" width="300" />
echo "$year, $caption" ?>
|