echo "<tr>
      <td><a href='details.php?lessonID=$lessonID'>Details for $subject( $lessonID )</a></td>
      <td>$subject</td>
      <td>$learningArea</td>
      <td>$noofstudents</td>
      <td>$minutes</td>
      <td>$class</td>
      <td> $ability</td>
      </tr>" ;

<?php
 
mysql_connect("localhost","root","");
 
mysql_select_db("student") or die("Unable to select database"); 
?>
 
<form name="form" action="result.php" method="get">
 
Subject   <input type="text" name="q" />
Topic <input type="text" name="r" />
Ability <input type="text" name="s" />
 
  <input type="submit" name="Submit" value="Search" />
</form>
 
<?php
  // Get the search variable from URL
 $q = $_GET['q'] ;
 
  $r = $_GET['r'] ;
 
  $s = $_GET['s'] ;
 
// Build SQL Query  
 $myquery = "select * from lesson where subject like '%".$q."%'  AND learningArea like '%".$r."%'  AND  ability like '%".$s."%'";
//echo $myquery ;
 $result = mysql_query ($myquery); 
 
 
 echo "<table>"  ;
echo "<tr><th>Lesson ID</th>";
echo "<th>Subject</th>";
echo "<th>Learning Area</th>";
echo "<th>No of Students</th>";
echo "<th>Time Period</th>";
echo "<th>Class</th>";
echo "<th>Ability</th></tr>";
 
while ($row= mysql_fetch_array($result)) 
 {
$lessonID = $row["lessonID"];  
  $subject = $row["subject"];
  $learningArea= $row["learningArea"];
    $noofstudent= $row["noofstudents"];
    $minutes= $row["minutes"];
    $class= $row["class"];
    $ability= $row["ability"];
 
//display the row
 
echo <<<EOD
<tr>
<td><a href="details.php?lessonID=$lessonID"> </a></td>
<td>$subject</td> 
<td>$learningArea</td> 
<td>$noofstudents</td> 
<td>$minutes</td>  
<td>$class</td>  
<td> $ability</td>  
</tr>
EOD;
}
echo "</table>";
 
?>