|
selectDatabase('coreDatabase');
$sql = mysql_query("SELECT * FROM peopletable WHERE type LIKE '%crumb%' AND surName<>'Lane' AND surName<>'Carpenter' AND surName<>'Roberts' ORDER BY surName");
$first=1;
//get presentation info
while ($row = mysql_fetch_row($sql)) {
$name=$row[1]." ".$row[3]." ".$row[2];
$scanText=" $scanText $name";
if ($first==1){
echo("$name ");
$first=0;
}else{
echo("| $name ");
}
}
?>
$ord=$_GET[order];
if($ord==$nothing){
$ord="ASC";
}
$sql = mysql_query("SELECT * FROM peopletable WHERE type LIKE '%crumb%' AND surName<>'Lane' AND surName<>'Carpenter' AND surName<>'Roberts' ORDER BY surName $ord");
$q='"';
//get presentation info
while ($row = mysql_fetch_row($sql)) {
$id=$row[0];
$name=$row[1].", ".$row[3]." ".$row[2];
echo("$name:
");
selectDatabase("AssetDatabase");
$sql2="SELECT * FROM staffpublicationtable WHERE pubOwner='$id' ORDER BY pubDate DESC";
//echo($sql2);
$result=mysql_query($sql2);
global $nam;
while ($row2 = mysql_fetch_row($result)) {
$nam="$row[2], $row[1]";
$scanText=" $scanText $nam ";
$scanText=" $scanText $row2[5] $row2[3] $row2[5] $row2[1] ";
if($row2[7]<>""){
$nam=$row2[7];
}
echo("$nam ($row2[5]) $q$row2[1]");
echo("$q ");
if($row2[3]<>""){
echo("$row2[3] ");
}
$nam="";
if ($row2[2]<>""){
?>
");?>
echo substr($row2[2],1,80);
//echo ($row2[2]); ?>
");?>
}
echo(" ");
}
}
?>
|
|