Virtual Publication

[insert_php]

$connect = mysql_connect(“localhost”, “elianyjma”, “72*pI$52”);
mysql_select_db(“elianyjma”, $connect);

$query=”select * from vwPublications where content is not null 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]