Subject: printing forum - subforum - post titles in search results
Where $query_text is a search string; Mysql connections and closings are omitted:
$select_unb_posts=mysql_query("SELECT ID, Thread, Subject, Msg FROM $unb_posts_table_name WHERE Subject LIKE '%$query_text%' OR Msg LIKE '%$query_text%' AND Subject!='';");
$mysql_num_rows_select_unb_posts=@mysql_num_rows($select_unb_posts);
if ($mysql_num_rows_select_unb_posts > 0) {
while ($mysql_fetch_row_select_unb_posts=@mysql_fetch_row($select_unb_posts)) {
$select_unb_threads=mysql_query("SELECT Forum FROM $unb_threads_table_name WHERE ID='".$mysql_fetch_row_select_unb_posts[1]."';");
$mysql_num_rows_select_unb_threads=@mysql_num_rows($select_unb_threads);
echo "<div><p>";
if ($mysql_num_rows_select_unb_threads > 0) {
while ($mysql_fetch_row_select_unb_threads=@mysql_fetch_row($select_unb_threads)) {
$select_unb_forums=mysql_query("SELECT Parent, Name FROM $unb_forums_table_name WHERE ID='".$mysql_fetch_row_select_unb_threads[0]."';");
$mysql_num_rows_select_unb_forums=@mysql_num_rows($select_unb_forums);
if ($mysql_num_rows_select_unb_forums > 0) {
while ($mysql_fetch_row_select_unb_forums=@mysql_fetch_row($select_unb_forums)) {
$unb_subforum_title=$mysql_fetch_row_select_unb_forums[1];
$select_unb_forums=mysql_query("SELECT Name FROM $unb_forums_table_name WHERE ID='".$mysql_fetch_row_select_unb_forums[0]."' LIMIT 1;");
$mysql_num_rows_select_unb_forums=@mysql_num_rows($select_unb_forums);
if ($mysql_num_rows_select_unb_forums > 0) {
while ($mysql_fetch_row_select_unb_forums=@mysql_fetch_row($select_unb_forums)) {
$unb_forum_title=$mysql_fetch_row_select_unb_forums[0];
if ($unb_forum_title!="") {
echo $unb_forum_title." - ";
}
if ($unb_subforum_title!="") {
echo $unb_subforum_title." - ";
}
}
}
}
}
}
}
echo $mysql_fetch_row_select_unb_posts[2]."...</p></div>\r\n";
}
}

englishextra
Show profile
Link to this post