Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:xampphtdocsprojectteachercourses-list.php on line 46
- <?php
- if ($_SESSION["isteacher"])
- {
- $con=mysql_connect($dbserver,$dbusername,$dbpassword);
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db($dbname, $con);
- $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)");
- echo "<table border='1'> <br />
- <tr>
- <th>ID:</th>
- <th>Course Name</th>
- <th>Description</th>
- <th>Subject-ID</th>
- <th>EDIT</th>
- <th>DELETE</th>
- </tr>";
- while($row = mysql_fetch_array($result)) // this is the error line
- {
- echo "<tr>";
- echo "<td>" . $row['cid'] . "</td>";
- echo "<td>" . $row['title'] . "</td>";
- echo "<td>" . $row['description'] . "</td>";
- echo "<td>" . $row['sname'] . "</td>";
- echo "<td><a href='courses-edit.php?id=" . $row['id']."'>EDIT</a></td>";
- echo "<td><a href='courses-delete.php?id=" . $row['id']."'>DELETE</a></td>";
- echo "</tr>";
- }
- echo "</table>";
- mysql_close($con);
- ?>
- $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)");
- $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)");
- subjects WHERE (courses.subjects-id==subjects.id)");
- here is the error ---------^^--------sould be =
Add Comment
Please, Sign In to add comment