Thank you so much Patricia,
I needed one more help from you, I am trying to show child guide below parent guide but I am missing something somewhere, can you help me to get this in homepage.
the below thing I try to get those things.
I am Using 4.6 version, splux theme:-
I try to write the mysql query in index.php on line 135 to get the child guide details below to parent guide on homepage in guide collection pages.
$pills = "<div class=\"feature-light p-3 mb-3\">" . _( "Need to start over? " ) . "<a href=\"index.php\" class=\"no-decoration\">$guide_name</a></div>";
$q_search = "select *, ss.subject_child from subject, subject_subject ss
WHERE active = '1'
AND subject_id = ss.
subject_child
AND ss.subject_child = $childguide[1];
AND type != 'Placeholder'
AND subject LIKE '$search_param'
ORDER BY subject";
$statement = $connection->prepare( $q_search );
$statement->execute();
$r_search = $statement->fetchAll();
and on line 235:-
$our_item = "<li title=\"{$title_hover}\"><i class=\"fa {$icon}\"></i> <a href=\"$guide_location\" class=\"no-decoration default\">" . htmlspecialchars_decode( $myrow[1] ) . "</a>
<ul><li>$childguide[1]</li></ul>
<div class=\"guide_list_bonus\">$list_bonus</div>
</li>";