Guest User

Untitled

a guest
Jan 21st, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:xampphtdocsprojectteachercourses-list.php on line 46
  2.  
  3. <?php
  4. if ($_SESSION["isteacher"])
  5. {
  6.  
  7. $con=mysql_connect($dbserver,$dbusername,$dbpassword);
  8. if (!$con)
  9. {
  10. die('Could not connect: ' . mysql_error());
  11.  
  12. }
  13. mysql_select_db($dbname, $con);
  14. $result = mysql_query("SELECT courses.id AS cid, courses.title, courses.description, courses.subjects-id, subjects.id AS sid, subjects.subjectname AS sname FROM courses, subjects WHERE (courses.subjects-id==subjects.id)");
  15. echo "<table border='1'> <br />
  16. <tr>
  17. <th>ID:</th>
  18. <th>Course Name</th>
  19. <th>Description</th>
  20. <th>Subject-ID</th>
  21. <th>EDIT</th>
  22. <th>DELETE</th>
  23. </tr>";
  24.  
  25. while($row = mysql_fetch_array($result)) // this is the error line
  26. {
  27. echo "<tr>";
  28. echo "<td>" . $row['cid'] . "</td>";
  29. echo "<td>" . $row['title'] . "</td>";
  30. echo "<td>" . $row['description'] . "</td>";
  31. echo "<td>" . $row['sname'] . "</td>";
  32. echo "<td><a href='courses-edit.php?id=" . $row['id']."'>EDIT</a></td>";
  33. echo "<td><a href='courses-delete.php?id=" . $row['id']."'>DELETE</a></td>";
  34. echo "</tr>";
  35. }
  36. echo "</table>";
  37.  
  38. mysql_close($con);
  39. ?>
  40.  
  41. $result = mysql_query("SELECT courses.id AS cid, courses.title, courses.description, courses.subjects-id, subjects.id AS sid, subjects.subjectname AS sname FROM courses, subjects WHERE (courses.subjects-id==subjects.id)");
  42.  
  43. $result = mysql_query("SELECT courses.id AS cid, courses.title, courses.description, courses.subjects-id, subjects.id AS sid, subjects.subjectname AS sname FROM courses, subjects WHERE (courses.subjects-id=subjects.id)");
  44.  
  45. subjects WHERE (courses.subjects-id==subjects.id)");
  46. here is the error ---------^^--------sould be =
Add Comment
Please, Sign In to add comment