There was a problem accessing your profile

[genzedu777]

Hi all,

 

I am still trying to figure what went wrong. It doesn't work over here.

 

The error shown was the {else} command

else {

echo '<p class="error">There was a problem accessing your profile.</p>';

}

 

I have attached my 4 sql tables for reference. Appreciate any advices....

 

<?php
$query3 = "SELECT ols.subject_level_id, sl.level_id, sl.subject_id, tl.level_name AS level_name, ts.subject_name AS subject_name " .
        "FROM tutor_overall_level_subject AS ols " .
	"INNER JOIN tutor_subject_level AS sl USING (subject_level_id) " .
        "INNER JOIN tutor_level AS tl USING (level_id) " .
        "INNER JOIN tutor_subject AS ts USING (subject_id) " .
	"WHERE ols.tutor_id = '" . $_GET['tutor_id'] . "'";


  $data3 = mysqli_query($dbc, $query3)
  or die(mysqli_error($dbc));

  if (mysqli_num_rows($data3) == 1) {

echo '<div id="panel4">';

	echo'<table><tr>'; // Start your table outside the loop... and your first row
	$count = 0; // Start your counter
	while($row3 = mysqli_fetch_array($data3)) {
		/* 	Check to see whether or not this is a *new* row
			If it is, then end the previous and start the next and restart the counter.
		*/
		if ($count % 5 == 0) { 
			echo "</tr><tr>"; $count = 0;
		}
		echo '<td class="label">' . $row3['level_name'] . '</td><td>' . $row3['subject_name'] . '</td>';
		$count++; //Increment the count
	} 
	echo '</tr></table><br/>'; //Close your last row and your table, outside the loop

echo '</div>'; //End of panel 4

} //End of if (mysqli_num_rows($data3) == 1)

else {
	echo '<p class="error">There was a problem accessing your profile.</p>';
}
?>

 

[attachment deleted by admin]