This is my code
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
mysql_connect("localhost","root","") or die(mysql_error());
echo"Connected to MySQL<br /><hr/>";
mysql_select_db("college") or die(mysql_error());
echo "Connected to database<br /><hr />";
$query = "select student.Rollno, departments.Dept_name, student.Name, student.PercentsgeSoFar from student inner join(departments
inner join studentdept on studentdept.Dept_id = departments.Dept_id)on student.Rollno = studentdept.Rollno ";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo $row['Rollno']. " " . $row['Dept_name ']." ". $row['Name']." ". $row['PercentageSoFar'];
echo "<br />";
}
?>
The result is :
376 Ankita
789 Arushi
567 Shubham
456 Goldie
Its not showing the other parameters like Dept_name Percentageso far.
Please help, WHAT SHOULD I DO?