[insert_php]
$connect = mysql_connect(“localhost”, “elianyjma”, “72*pI$52”);
mysql_select_db(“elianyjma”, $connect);
$query=”select * from vwPublications where publicationType=’exhibition’ order by idLanguage,publicationType,surname,name,publicationTypeTitle;”;
$result = mysql_query($query);
$direction=”ltr”;
if($language==”HE”){
$direction=”rtl”;
}
$cssStyle=”text-align:justify;direction:”.$direction;
Print “
$page=”/publication-content/”;
$artistPage=”/biography-detail/”;
$link=”#”;
$publicationType=””;
if (mysql_num_rows($result)) {
Print ““;
while ($qry = mysql_fetch_array($result)) {
$language=$qry[‘idLanguage’];
if($qry[‘publicationTypeTitle’]!=$publicationType){
$publicationType=$qry[‘publicationTypeTitle’];
Print “
“;
Print $publicationType;
Print “
“;
}
if($qry[‘publicationLink’]!=null){
$link=$qry[‘publicationLink’];
}else{
$link=$page.”?id=”.$qry[‘idPublication’].”&language=”.$language;
}
$linkArtist=$artistPage.”?id=”.$qry[‘idPeople’].”&language=”.$language;
Print ““;
Print ““;
Print $qry[‘surname’] . ” ” . $qry[‘name’];
Print ““;
Print ” “;
Print $qry[‘title’];
Print ““;
if($qry[‘yearOfPublication’]!=null){
Print ” (“;
Print $qry[‘yearOfPublication’];
Print “)”;
}
Print ” “;
Print $qry[‘languageDescription’];
Print ““;
}
}
Print “
“;
mysql_close($connect);
[/insert_php]