Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. $strQ = "SELECT Count(DenServRen.Description) as Total, Institute.Autokey as InKey
  2. FROM StudentMain
  3. LEFT JOIN EnrollmentMain ON StudentMain.StudentNo = EnrollmentMain.StudentNo
  4. INNER JOIN CourseProgram ON EnrollmentMain.Coursekey = CourseProgram.Autokey
  5. INNER JOIN Institute ON CourseProgram.Institutekey = Institute.Autokey
  6. LEFT JOIN StudentDental ON StudentDental.Studentkey = StudentMain.Autokey
  7. LEFT JOIN StudentDentalDetl ON StudentDentalDetl.Dentalkey = StudentDental.Autokey
  8. LEFT JOIN DenServRen ON StudentDentalDetl.DenResult = DenServRen.Autokey
  9. WHERE StudentDentalDetl.DentalDate is not null and DenServRen.Description = '$arrDisDental[$x]'and Institute.Autokey = '$arrInstitute[$i]' Group by Institute.Autokey";
  10.  
  11. $result = mySelectDB($strQ, $intHandle);
  12. while($objResult = mysql_fetch_object($result)){
  13. $Total = $objResult->Total;
  14. echo "$Total";
  15. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement