Simple Error but where?

PHP
1

Its a search result page…As you see in the red cirlces,its the criteria I search for, the database accepts my input but doesnt show that up in the table.
Here is the result_process.php file. Can anyone kindly find out whats wrong?
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=“http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1” />
<title>Wellcome To JGCI</title>

&lt;?php
include"config.php";
$roll=$_POST['roll'];
$session=$_POST['session'];
 
 $sql="select * from `ssc` where roll='$roll' and session='$session' ";
  $result=mysql_query($sql);
  $alvi=mysql_num_rows($result);
	if($alvi&gt;0){
 
 echo "&lt;table border='1' align='center' cellpadding='10'&gt;
    &lt;tr&gt;
	&lt;td colspan=5&gt;See Your Result : : = $roll = : : &lt;/td&gt;
	&lt;td colspan=5&gt;See Your Session : : = $session = : : &lt;/td&gt;
	&lt;/tr&gt;
	
    &lt;tr&gt;
	&lt;th&gt;Student_Name&lt;/th&gt;
	&lt;th&gt;Father_Name&lt;/th&gt;
	&lt;th&gt;Mother_Name&lt;/th&gt;
	&lt;th&gt;Roll&lt;/th&gt;
	&lt;th&gt;Session&lt;/th&gt;
	&lt;th&gt;Student_type&lt;/th&gt;
	&lt;th&gt;GPA&lt;/th&gt;
	
	&lt;/tr&gt;";
	while($row = mysql_fetch_array($alvi)){
	                 echo "&lt;tr&gt;";
					 echo"&lt;td&gt;" . $row['s_name'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['s_f_name'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['s_m_name'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['roll'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['session'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['type'] . "&lt;/td&gt;";
					 echo"&lt;td&gt;" . $row['gpa'] . "&lt;/td&gt;";
					 
					 
			 echo"&lt;/tr&gt;";}
	echo"&lt;/table&gt;";}
  else {
		print "&lt;p align='center'&gt;Wrong Roll number or Session name. Please inseart again.&lt;/p&gt;";
		}
		?&gt;
		&lt;p align="center"&gt;&lt;a href="result.php"&gt;Go To Result Page&lt;/a&gt;&lt;/p&gt;
		    &lt;/div&gt;
		&lt;div class="body"&gt;&lt;/div&gt;
		&lt;/div&gt;
		&lt;/body&gt;
		&lt;/html&gt;
2

Actually I don’t understand what’s in those red circles.

An off topic question: are you using PHP 4 ?

3

The problem is that you’re passing $alvi to mysql_fetch_array, when $alvi was your mysql_num_rows count, not the actual query.