Children sexually abused in foster/adoptive homes
⬤
public
$sql = "SELECT n.nid FROM {node} n INNER JOIN {content_field_type_of_abuse} t ON (t.nid = n.nid and t.vid = n.vid) WHERE field_type_of_abuse_value REGEXP '^Sexual' ORDER BY n.title ASC";
$result = pager_query(db_rewrite_sql($sql), 200, 0);
while ($data = db_fetch_object($result)) {
$blog_node = node_load($data->nid);
print node_view($blog_node, TRUE);
}
print theme('pager', NULL, 200);
?>
>