Revision: 3067
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at May 31, 2007 23:36 by methnen
Initial Code
global $DB; $rel_weblog_id = '4'; $rel_field_value = '{rel_field}'; $sql = " SELECT * FROM exp_relationships LEFT JOIN exp_weblog_data, exp_weblog_titles ON ( exp_weblog_data.entry_id = exp_relationships.rel_child_id AND exp_weblog_titles.entry_id = exp_relationships.rel_child_id ) WHERE exp_relationships.rel_id = '$rel_field_value' AND exp_weblog_titles.weblog_id = '$rel_weblog_id' "; // Query for rel_child_id in the exp_relationships table $rel_data_query = $DB->query($sql); if($rel_data_query->num_rows > 0) { foreach($rel_entry_query->result as $row) { $entry_id = $row['entry_id']; $title = $row['title']; } }
Initial URL
Initial Description
Initial Title
Related Entries Forwards
Initial Tags
textmate
Initial Language
PHP