"; 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; if ($Publisher <> "") echo "
Publisher: $Publisher (more)."; echo "
Added or changed: "; echo $Bearbeitet; echo "

\n"; } $SQLStmt = "SELECT JournalID, Name, Description, eJournal, Info, ToC, Announcement, Abstracts, Articles, Link2, Link2Content, Comment, Publisher, 2nd_Title, DATE_FORMAT(Bearbeitet, '%M %d, %Y') AS Datum FROM journals WHERE TO_DAYS(NOW()) - TO_DAYS(Bearbeitet) <= 90 ORDER BY Bearbeitet DESC, 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 added/changed during the last 90 days

"; 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) ){ print_record(); $i++; } ?>
armin.guenther@psycline.org © Armin Günther