' . $anewsRec['title'] . ''; if (strlen($anewsRec['picture_name'])>0){ $MainNewsList.=' '. $anewsRec['title'] .'

'; $MainNewsList.='

' . $anewsRec['caption'] . '

'; }else{ //$MainNewsList.=' '. $anewsRec['title'] .'

'; } $MainNewsList .= '

' . $anewsRec['news_text']; if (strlen($anewsRec['external_link'])>0){ $MainNewsList .= '
» ' . $anewsRec['external_link_title'] . '

'; }else{ if (strlen($anewsRec['internal_link'])>0){ $MainNewsList .= '
» ' . $anewsRec['internal_link_title'] . '

'; } } $MainNewsList .= "\n"; } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); /*END GET THE PRIMARY NEWS*/ if (strlen($MainNewsList)>0){ $MainNewsList= '

' . $MainNewsList .'

'; }else{ $MainNewsList=""; } $divleft=""; $divright=""; /*GET THE SECONDARY NEWS?*/ $sql = "SELECT tbl_front_page.* FROM tbl_front_page WHERE tbl_front_page.news_id<>1 "; $sqlOrder = "ORDER BY tbl_front_page.sortorder ,tbl_front_page.news_id asc "; $sql.= $sqlOrder ; $isright=1; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($sql) or die("Query failed : " . mysql_error()); $isRowOdd = true; while($anewsRec = mysql_fetch_array($rstnews)) { if ($isright==1){ $isright=0; $divright .= '

'; $divright .= '

' . $anewsRec['title'] . '

'; if (strlen($anewsRec['picture_name'])>0){ $divright.=' '. $anewsRec['title'] .'

'; $divright.='

' . $anewsRec['caption'] . '

'; }else{ //$divright.=' '. $anewsRec['title'] .'

'; } $divright .= '

' . $anewsRec['news_text']; if (strlen($anewsRec['external_link'])>0){ $divright .= '
» ' . $anewsRec['external_link_title'] . '

'; }else{ if (strlen($anewsRec['internal_link'])>0){ $divright .= '
» ' . $anewsRec['internal_link_title'] . '

'; } } $divright .= '

'; }else{ $isright=1; $divleft .= '

'; $divleft .= '

' . $anewsRec['title'] . '

'; if (strlen($anewsRec['picture_name'])>0){ $divleft.=' '. $anewsRec['title'] .'

'; $divleft.='

' . $anewsRec['caption'] . '

'; }else{ //$divleft.=' '. $anewsRec['title'] .'

'; } $divleft .= '

' . $anewsRec['news_text']; if (strlen($anewsRec['external_link'])>0){ $divleft .= '
» ' . $anewsRec['external_link_title'] . '

'; }else{ if (strlen($anewsRec['internal_link'])>0){ $divleft .= '
» ' . $anewsRec['internal_link_title'] . '

'; } } $divleft .= '

'; if ($isright==0){ $divleft .= '

'; } $divleft .= "\n"; } } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); /*END GET THE SECONDARY NEWS?*/ /*GET THE BLOG */ $bsql = "SELECT tbl_blog.blog_id,tbl_blog.title, tbl_user.blogname, tbl_blog.title, tbl_blog.blog_text, tbl_blog.item_date FROM tbl_blog INNER JOIN tbl_user ON tbl_blog.user_id = tbl_user.user_id WHERE tbl_user.user_id= " .$FRONTPAGE_BLOGID . " and tbl_blog.isHidden=0 AND tbl_blog.item_date <= curdate() ORDER BY tbl_blog.item_date DESC LIMIT 0, 1"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $blogoutput .= "

jpr/blog: " . $anewsRec['title'] . '

'; $item_date=$anewsRec['item_date']; if (strlen($item_date)>0) { $item_date=fullworddate($item_date); if (dateDiff("d",$item_date,date("d-M-Y"))>14) { $item_date=""; }else{ $item_date="
" . $item_date; } } $blogoutput .= '

From the Executive Director' . $item_date . '

'; $shortdesc =$anewsRec['blog_text'] ; if (strlen($shortdesc)>200) { $shortdesc = substr($shortdesc, 0, strpos($shortdesc," ",175)) . "..."; $shortdesc = fixstring (strip_tags($shortdesc)); } $blogoutput .= "

" . $shortdesc . "

"; $blogoutput .= '

» read blog'; /* $blogoutput .= '
» view all blogs

'; */ $blogoutput .= "\n"; } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); /*END GET THE BLOG*/ // $divleft= '

' . $blogoutput . '

' . $divleft; /*GET THE INTERNAL NEWS */ $bsql = "SELECT tbl_news.news_id, tbl_news.title, tbl_news.news_text, tbl_news.item_date FROM tbl_news WHERE tbl_news.internal=1 AND tbl_news.isHidden=0 AND tbl_news.item_date <= CURRENT_DATE AND tbl_news.dateexpires > CURRENT_DATE ORDER BY tbl_news.item_date DESC LIMIT 0, 3"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $item_date=$anewsRec['item_date']; if (strlen($item_date)>0) fullworddate($item_date); $item_date=fullworddate($item_date); $newsoutput .= '

' . $item_date . '
'; $newsoutput .= ' ' . $anewsRec['title'] .''; $newsoutput .= "\n"; } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); if( strlen($newsoutput)>0) $newsoutput = '

Latest news

' . $newsoutput . '

» full news list

'; /*GET THE INTERNAL NEWS */ /*GET THE EVENTS NEWS */ $bsql = "SELECT tbl_event.event_id, tbl_event.item_date, tbl_event.title, tbl_event.eventvenue, tbl_event.event_text FROM tbl_event WHERE tbl_event.isHidden=0 AND item_date>=Current_Date ORDER BY tbl_event.item_date ASC LIMIT 0, 2"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $item_date=$anewsRec['item_date']; if (strlen($item_date)>0) $item_date=fullworddate($item_date); $eventsoutput .= '

' . $item_date ; if( strlen($anewsRec['eventvenue'] )>0) $eventsoutput .= ': ' . $anewsRec['eventvenue'] ; $eventsoutput .= '
'; $eventsoutput .= ' ' . $anewsRec['title'] .'

'; } mysql_free_result($rstnews); if (strlen($eventsoutput)>0 ){ $eventsoutput = "

Future events

" . $eventsoutput ; $eventsoutput .= '

» full events list

'; $eventsoutput .= "\n"; } /* close db connection */ mysql_close($dbConn); /*GET THE EVENTS NEWS */ /*GET THE PUBLICATIONS */ $bsql = "SELECT tbl_article.article_id, tbl_article.title, tbl_article.pubdate FROM tbl_article WHERE (((tbl_article.parent_article_id)=4) AND ((tbl_article.isHidden)=0) AND tbl_article.pubdate <= curdate()) ORDER BY tbl_article.pubdate DESC LIMIT 0, 2"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $item_date=$anewsRec['pubdate']; if (strlen($item_date)>0) fullworddate($item_date); $item_date=fullworddate($item_date); $publicationsoutput .= '

' . $item_date . '
'; $publicationsoutput .= ' ' . $anewsRec['title'] .'

'; } mysql_free_result($rstnews); if (strlen($publicationsoutput)>0 ){ $publicationsoutput = "

Recent publications

" . $publicationsoutput ; $publicationsoutput .= "\n"; $publicationsoutput .= '

» View all publications

'; } /* close db connection */ mysql_close($dbConn); /*GET THE PUBLICATIONS */ /*GET THE NEWSLETTER SUBSCRIPTION */ $bsql = "SELECT tbl_article.article_id, tbl_article.title FROM tbl_article WHERE (((tbl_article.parent_article_id)=7) AND ((tbl_article.isHidden)=0)) ORDER BY tbl_article.sortorder LIMIT 0, 1"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $magazineoutput .= '' . $anewsRec['title'] .'

'; } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); /*GET THE NEWSLETTER SUBSCRIPTION */ /*GET THE NEWSLETTER */ $newsletteroutput=""; $bsql = "SELECT tbl_newsletter.*, tbl_newsletter.isHidden, tbl_newsletter.item_date FROM tbl_newsletter WHERE (((tbl_newsletter.isHidden)=0) AND ((tbl_newsletter.item_date)<=CURRENT_DATE())) ORDER BY tbl_newsletter.item_date DESC limit 0,1"; /* open db connection */ $dbConn = mysql_connect($dbHost, $dbEditorUser, $dbEditorPass) or die("Could not connect : " . mysql_error()); mysql_select_db($dbName) or die("Could not select database"); /* retrieve news data */ $rstnews = mysql_query($bsql) or die("Query failed : " . mysql_error()); while($anewsRec = mysql_fetch_array($rstnews)) { $newsletteroutput .='

The ' . $anewsRec['Newsletter_Title'] .' edition of the jpr/ news is now available for download.

'; $newsletteroutput .='

'; $newsletteroutput .=' ' . $anewsRec['PictureName'] .'

'; $newsletteroutput .='

» View all newsletters

'; } mysql_free_result($rstnews); /* close db connection */ mysql_close($dbConn); if (strlen($newsletteroutput)>0){ $newsletteroutput = "

jpr/ news

" . $newsletteroutput ; } /*END GET THE NEWSLETTER */ ?> JPR - Institute for Jewish Policy Research

about us | contact us | site map

JPR apologizes for any inconvenience while our website has been down for essential maintenance.

Annual accounts

Download our 2007 accounts
Download our 2006 accounts

Subscribe to updates

If you would like to receive periodic updates about JPR activities, please supply your details below.

» privacy policy

jpr/ news

» view all issues

EAJC

The mission of the European Association for Jewish Culture (EAJC) is to enhance Jewish life by fostering and supporting artistic creativity and achievement, assisting scholarly research, and encouraging access to Jewish culture across Europe.

» Visit EAJC web site