"; echo "Edit | \n"; echo "|
Titre | \n"; $CurrTitle=mysql_result($objects,$i,'Title'); echo "$CurrTitle "; echo " \n"; echo " | \n"; echo "
Themes | \n"; echo "";
$k=0;
while ($k < mysql_num_rows($Objects_Themes)) {
$CurrThemeId= mysql_result($Objects_Themes,$k,'ThemeId');
$TypesD = mysql_query("SELECT * FROM Themes WHERE Id=$CurrThemeId");
echo mysql_result($TypesD,0,'GroupFrench').": ";
echo mysql_result($TypesD,0,'TitleFrench');
echo " "; $k++; } echo " | \n";
echo "
Start | \n"; echo "".mysql_result($objects,$i,'BeginningProject')." | \n"; echo "
End | \n"; echo "".mysql_result($objects,$i,'EndProject')." | \n"; echo "
Location | \n"; echo ""; $laloc=mysql_result($objects,$i,'Location'); if (strstr($laloc, "http://")) { echo ""; } echo $laloc; if (strstr($laloc, "http://")) { echo ""; } echo " | \n"; echo "
Tecfa Author(s) | \n"; echo ""; if ($zequeryAuthorTecfa) { $zz=0; while ($zz < mysql_num_rows($zequeryAuthorTecfa)) { $QID=mysql_result($zequeryAuthorTecfa,$zz,'AuthorTecfaId'); if (getUserHomepage($QID)) { echo ""; } echo getUserRealName($QID); if (getUserHomepage($QID)) { echo ""; } echo " "; $zz++; } } $link = mysql_pconnect("tecfa2.unige.ch","nobody","") or die( "Unable to connect to SQL server"); mysql_select_db('campus', $link) or die ( "Unable to select database"); echo " | \n"; echo "
External Author(s) | \n"; echo ""; if ($zequeryAuthorExt) { $zz=0; while ($zz < mysql_num_rows($zequeryAuthorExt)) { echo mysql_result($zequeryAuthorExt,$zz,'AuthorExternal')." "; $zz++; } } echo " | \n"; echo "
Contributors | \n"; echo "".mysql_result($objects,$i,'Contributors')." | \n"; echo "
Keywords | \n"; echo ""; if ($zequeryKeywords) { $zz=0; while ($zz < mysql_num_rows($zequeryKeywords)) { $newquery=mysql_query("SELECT * FROM Keywords WHERE Id=".mysql_result($zequeryKeywords,$zz,'KeywordId')); echo mysql_result($newquery,0,'KeyFrench')." "; $zz++; } } echo " | \n"; echo "
FullReference | \n"; echo "".mysql_result($objects,$i,'FullReference')." | \n"; echo "
Abstract | \n"; echo "".mysql_result($objects,$i,'Abstract')." | \n"; echo "
Description | \n"; echo "".mysql_result($objects,$i,'Description')." | \n"; echo "
Presentation | \n"; echo "".mysql_result($objects,$i,'Presentation')." | \n"; echo "
MimeType | \n"; echo "".mysql_result($objects,$i,'MimeType')." | \n"; echo "
Support | \n"; echo "".mysql_result($objects,$i,'Support')." | \n"; echo "
SizeOf | \n"; echo "".mysql_result($objects,$i,'SizeOf')." | \n"; echo "
Version | \n"; echo "".mysql_result($objects,$i,'Version')." | \n"; echo "
Platform | \n"; echo "".mysql_result($objects,$i,'Platform')." | \n"; echo "
Coverage | \n"; echo "".mysql_result($objects,$i,'Coverage')." | \n"; echo "
PriceCode | \n"; echo "".mysql_result($objects,$i,'PriceCode')." | \n"; echo "
Publisher | \n"; echo "".mysql_result($objects,$i,'Publisher')." | \n"; echo "
AvailabilityDate | \n"; echo "".mysql_result($objects,$i,'AvailabilityDate')." | \n"; echo "
Expiration | \n"; echo "".mysql_result($objects,$i,'ExpirationDate')." | \n"; echo "
LastModifiedDate | \n"; echo "".mysql_result($objects,$i,'LastModifiedDate')." | \n"; echo "
PublicationDate | \n"; echo "".mysql_result($objects,$i,'PublicationDate')." | \n"; echo "
Objective | \n"; echo "".mysql_result($objects,$i,'Objective')." | \n"; echo "
Prerequisite | \n"; echo "".mysql_result($objects,$i,'Prerequisite')." | \n"; echo "
Pedagogy | \n"; echo "".mysql_result($objects,$i,'Pedagogy')." | \n"; echo "
TECFAAudience | \n"; echo ""; $toutaud=explode(",",mysql_result($objects,$i,'TECFAAudience')); $q=0; while ($q < sizeOf($toutaud)) { $yaquery=mysql_query("SELECT * FROM TECFA_Audience WHERE Id =".$toutaud[$q]); echo mysql_result($yaquery,0,'Audience')." "; $q++; } # $newquery=mysql_query("SELECT * FROM TECFA_Audience WHERE Id IN(".mysql_result($objects,$i,'TECFAAudience').")"); # echo mysql_result($newquery,0,'Audience')." "; echo " | \n"; echo "
InteractivityLevel | \n"; echo "".mysql_result($objects,$i,'InteractivityLevel')." | \n"; echo "
LearningLevel | \n"; echo "".mysql_result($objects,$i,'LearningLevel')." | \n"; echo "
Structure | \n"; echo "".mysql_result($objects,$i,'Structure')." | \n"; echo "
Metametadata | \n"; echo "".mysql_result($objects,$i,'Metametadata')." | \n"; echo "
Rights | \n"; echo "".mysql_result($objects,$i,'Rights')." | \n"; echo "
Scheme | \n"; echo "".mysql_result($objects,$i,'Scheme')." | \n"; echo "
Financing | \n"; echo "".mysql_result($objects,$i,'Financing')." | \n"; echo "
BeginningProject | \n"; echo "".mysql_result($objects,$i,'BeginningProject')." | \n"; echo "
EndProject | \n"; echo "".mysql_result($objects,$i,'EndProject')." | \n"; echo "
RelatedPublications | \n"; echo "";
$zurl=explode(",",mysql_result($objects,$i,'RelatedPublications'));
$o=0;
while ($o< sizeOf($zurl)) {
echo "".$zurl[$o]." "; $o++; } echo " | \n";
echo "
RelatedUrl | \n"; echo "";
$zurl=explode(",",mysql_result($objects,$i,'RelatedUrl'));
$o=0;
while ($o< sizeOf($zurl)) {
echo "".$zurl[$o]." "; $o++; } echo " | \n";
echo "
RelatedObjects | \n"; echo "".mysql_result($objects,$i,'RelatedObjects')." | \n"; echo "