"Cross Sectional Psychology Journals", "Clinical"=>"Clinical Psychology", "Cognitive"=>"Cognitive Psychology", "Developmental"=>"Developmental Psychology", "Child"=>"Child Psychology", "Geronto"=>"Gerontopsychology", "Pedagogical"=>"Education and Educational Psychology", "Family"=>"Family Psychology", "Health"=>"Health", "Economic"=>"Industrial- and Organizational Psychology", "Methode"=>"Methods and Methodology", "Perception"=>"Perception", "Personality"=>"Personality", "Psychiatry"=>"Psychiatry", "Psychoanalysis"=>"Psychoanalysis", "Linguistic"=>"Psycholinguistic and Language", "Social"=>"Social Psychology", "Sociology"=>"Sociology"); $search = true; $Bedingung=""; // maximum number of results to display $results = 2000; function print_record() { global $Description, $Name, $Sec_Title, $eJournal, $Info, $Announcement, $ToC, $Link2, $Comment, $Link2Content, $Publisher, $Result, $i; $Description=mysql_result($Result,$i,"Description"); $eJournal=mysql_result($Result,$i,"eJournal"); $Info=mysql_result($Result,$i,"Info"); $Announcement=mysql_result($Result,$i,"Announcement"); $ToC=mysql_result($Result,$i,"ToC"); $Abstracts=mysql_result($Result,$i,"Abstracts"); $Articles=mysql_result($Result,$i,"Articles"); $Link2=mysql_result($Result,$i,"Link2"); $Link2Content=mysql_result($Result,$i,"Link2Content"); $Comment=mysql_result($Result,$i,"Comment"); $Name=mysql_result($Result,$i,"Name"); $Sec_Title=mysql_result($Result,$i,"2nd_Title"); $Publisher=mysql_result($Result,$i,"Publisher"); echo "
"; echo ""; echo $Name. ""; if ($eJournal == 1) {echo " (eJournal)";} echo "
"; if ($Sec_Title <> "") echo "$Sec_Title"; if ($Description <> "") echo "

"" . $Description . ""

"; echo "

Online: "; if ($Info == 1) echo "Journal information. "; if ($Announcement <> "") echo "Journal announced for $Announcement. "; if ($ToC <> "") echo "Tables of contents $ToC. "; if ($Abstracts <> "") echo "Abstracts $Abstracts. "; if ($Articles <> "") echo "Free full text articles $Articles "; if (($Link2 <> "") || ($Comment <> "")) echo "
Links & Hints: "; if ($Link2 <> "") echo "$Link2Content"; if (($Link2 <> "") && ($Comment <> "")) echo "| "; if ($Comment <> "") echo $Comment; echo "

\n"; } $SQLStmt = "SELECT JournalID, Name, Description, eJournal, Info, ToC, Announcement, Abstracts, Articles, Link2, Link2Content, Comment, 2nd_Title, Publisher FROM journals WHERE Publisher ='" . $Verlag . "' ORDER BY Name"; mysql_connect($host,$user,$passwd); mysql_select_db($Dbname); $Result = mysql_query($SQLStmt); $Result_count = MYSQL_NUM_ROWS($Result); $SQLStmt2 = "SELECT * FROM journals"; $Result2 = mysql_query($SQLStmt2); $DB_size = MYSQL_NUM_ROWS($Result2) ?> PSYCLINE: Your Guide to Psychology and Social Science Journals on the Web
Journals published by

"; if ($Result_count > $results) { echo "More than $results journal(s) found! First $results journals shown."; } else { echo "$Result_count journal(s) found. $DB_size journals in database."; }; echo "

\n"; $i = 0; // countervariable WHILE ( ($i < $Result_count) && ($i < $results) && ($search)){ print_record(); $i++; } ?>
armin.guenther@psycline.org © Armin Günther