problem1.
I am trying to display some contents inserted into a database with php with hyper links and a little sentence using substrings just like google search,after I have used a wild card search to search and display the page,the result is a one page display but what I want is several hyperlinks with some text like google.
problem 2.
when the hyper link is clicked I want a whole page or chapter to be displayed.

try something like this

1. search.php
$result = array(, )
foreach($result as $links) {
// Your links goes here
// truncate some part of the text,
echo "<a href='full_search.php?content_it="{$links['id']}">. $links['title'] . "</a>";
}

2. full_search.php
# Remember to escape incoming data
$content_id = (isset($_GET['content_id']) ? intval($_GET['content_id']) : 0;

if($content_id > 0) {
// Here query or method to fetch single row
// SELECT * FROM table WHERE content_id = $content_id
//
}else{
// You can display error message here
}

The above code may not work, i`m just trying to show you steps to take
Learn how to use Framework instead of hardcore coding.

can I do this,is the syntax correct.

$result = array("select * from database";
foreach($result as $links) {
echo $links
echo "<a href='full_search.php?content_it="{$links['id']}">. $links['title'] . "</a>";
}
would it display several rows??

can I also use the for each loop in place of this while loop

while($row = mysql_fetch_array($result)){
}

HELLO SHOK,
THE SOLUTION TO YOUR PROBLEM IS HERE: https://www.nairaland.com/nigeria/topic-592012.0.html !