You searched Groups for \"".$_POST['group_search_box']."\".
";
echo "There are ".$query->num_rows." results.
";
foreach($query->result as $row)
{
?>
-
query("SELECT exp_user_groups_topics.user_group_id, exp_user_groups_topics.topic_id, exp_user_groups_topics.subject, exp_user_groups_topics.entry_date
FROM exp_user_groups, exp_user_groups_topics
WHERE (
exp_user_groups_topics.subject LIKE '%".$_POST['group_search_box']."%'
OR exp_user_groups_topics.body LIKE '%".$_POST['group_search_box']."%'
)
AND exp_user_groups_topics.status = 'open'
AND (
exp_user_groups.user_group_type = 'public'
OR exp_user_groups.user_group_type = 'moderated'
)
AND exp_user_groups.user_group_id = exp_user_groups_topics.user_group_id"
);
$num_rows=$query->num_rows;
if ( $query->num_rows == 0 )
{
echo "No discussion topics could be found matching your search.";
}
else {
echo "
You searched Discussions topics for \"".$_POST['group_search_box']."\".
";
echo "There are ".$query->num_rows." results.
";
foreach($query->result as $row)
{
?>
-
query(
"SELECT exp_user_groups_topics.user_group_id, exp_user_groups_replies.reply_id, exp_user_groups_replies.body, exp_user_groups_replies.entry_date, exp_user_groups_topics.subject, exp_user_groups_topics.topic_id
FROM exp_user_groups, exp_user_groups_replies, exp_user_groups_topics
WHERE exp_user_groups_replies.body LIKE '%".$_POST['group_search_box']."%'
AND exp_user_groups_replies.status = 'open'
AND (
exp_user_groups.user_group_type = 'public'
OR exp_user_groups.user_group_type = 'moderated'
)
AND exp_user_groups.user_group_id = exp_user_groups_topics.user_group_id
AND exp_user_groups_topics.topic_id = exp_user_groups_replies.topic_id"
);
$num_rows=$query->num_rows;
if ( $query->num_rows == 0 )
{
echo "No replies could be found matching your search.";
}
else {
echo "
You searched Discussion replies for \"".$_POST['group_search_box']."\".
";
echo "There are ".$query->num_rows." results.
";
foreach($query->result as $row)
{
?>
Permalink - in the
topic.