$one_month_seconds) { $sql2 = "UPDATE $newsletters_table SET yn_live = 'Y' WHERE newsletter_id = $newsletter_id "; $result2 = mysql_query($sql2, $connection) or die("could not activate newsletter for newsletter_id $newsletter_id"); // echo "

$newsletter_date newsletter is now active.

"; } } // set to display on web all items in live newsletters // other than jobs (3) and events (17), which are handled separately $sql = "UPDATE $items_table as ti, $newsletters_table as tn SET ti.yn_web = 'Y' WHERE tn.yn_live = 'Y' AND ti.newsletter_id = tn.newsletter_id AND ti.yn_web = 'N' AND ti.type_id <> 3 AND ti.type_id <> 17 "; $result = mysql_query($sql, $connection) or die("could not activate items for live newsletters"); // set to NOT display on web all jobs with expiration date before today $sql = "UPDATE $items_table SET yn_web = 'N' WHERE type_id = 3 AND date_expire < now() "; $result = mysql_query($sql, $connection) or die("could not de-activate jobs in housekeeping"); // set to NOT display on web all events with end date before today $sql = "UPDATE $items_table SET yn_web = 'N' WHERE type_id = 17 AND date_end < now() "; $result = mysql_query($sql, $connection) or die("could not de-activate events in housekeeping"); // END HOUSEKEEPING // MAIN SECTION show_header('PRRAC - Poverty & Race Research Action Council','Poverty & Race Research Action Council','','N','N'); ?>


Event

Join PRRAC and the Lawyers Committee on April 25th for an in-depth look at the 50th anniversary of the Fair Housing Act:

See the agenda here

Register here!


New on PRRAC's Website

Current issue of Poverty & Race"; ?>

Court papers in Open Communities Alliance et al v. Carson (2017-18)

"Fair Housing and Environmental Justice: New Strategies and Challenges," (Megan Haberle, Journal of Affordable Housing, January 2018)

Comments on New Federal Strategy to Reduce Childhood Lead Exposures (November 2017)

"Disrupting the Reciprocal Relationship between Housing and School Segregation" (Philip Tegeler and Michael Hilton, November 2017)

Amicus Brief in City of Oakland v. Wells Fargo (N.D. Cal. 2017)

Equity Considerations in Climate Adaptation Plans: A Call for Advocacy (October 2017)

Civil Rights in the Deregulatory State

PRRAC Updates (2011-16)

PRRAC in the News

Follow PRRAC on Twitter:

Follow PRRAC on Facebook:

Current Projects/Initiatives
Housing
HUD Advocacy (by program)
Section 8 Mobility Housing
LIHTC LIHTC
Affirmitively Furthering Fair Housing
Fair Housing & Community Development
Education
School Diversity
Sheff Movement (Hartford)
Educational Equity
Housing/Education Link
Administrative State and Civil Rights
Health/Environment/Transportation
International Human Rights in the U.S.
Civil Rights History
One Nation Indivisible


Featured Website



Furthering Fair Housing