'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 "); } } ?>

'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]<>""){ ?> ");?>
");?> "); } } ?>