roanic Posted February 10, 2014 Share Posted February 10, 2014 <?php include('Connect.php'); $query ="SELECT * From Section order by sectCode ASC"; $result = mysql_query($query); mysql_close($con); $ctr = 0; echo" <body> <TABLE valign = top align = center border = 0 width =85% cellpadding = 2 cellspacing = 0 bgcolor = aliceblue> <tr><th colspan = 5 align = center>List of Classes <tr><td colspan =5><hr> <tr><th bgcolor = white align = left> <th bgcolor = white align = center><font color =black>Section <th bgcolor = white align = center><font color =black>Subject Code <th bgcolor = white align = center><font color = black>Subject Description <th bgcolor = white align = center><font color = black>Time/Day <tr><td colspan =5><hr>"; $ctr = 1; while ($rec = mysql_fetch_row($result)) { echo" <tr> <td align = center>$ctr <td>$rec[1] <td>$rec[2] <td>$rec[3] <td>$rec[4] </tr>"; $ctr++; } $ctr; echo "<tr><td colspan=5><hr>Total no. of SectionsPrinter: $ctr <tr><td colspan=5><hr> </table> </body>"; ?> Link to comment https://forums.phpfreaks.com/topic/286083-warning-mysql_fetch_row-expects-parameter-1-to-be-resource-boolean-given-in-cxampphtdocsexer10prtsectphp-on-line-20/ Share on other sites More sharing options...
PravinS Posted February 10, 2014 Share Posted February 10, 2014 check you SQL query, remove space between FROM and table name from SQL query $query ="SELECT * From Section order by sectCode ASC"; Link to comment https://forums.phpfreaks.com/topic/286083-warning-mysql_fetch_row-expects-parameter-1-to-be-resource-boolean-given-in-cxampphtdocsexer10prtsectphp-on-line-20/#findComment-1468372 Share on other sites More sharing options...
roanic Posted February 10, 2014 Author Share Posted February 10, 2014 check you SQL query, remove space between FROM and table name from SQL query $query ="SELECT * From Section order by sectCode ASC"; its still now working thank you for replying Link to comment https://forums.phpfreaks.com/topic/286083-warning-mysql_fetch_row-expects-parameter-1-to-be-resource-boolean-given-in-cxampphtdocsexer10prtsectphp-on-line-20/#findComment-1468373 Share on other sites More sharing options...
PravinS Posted February 10, 2014 Share Posted February 10, 2014 echo the SQL query and execute it in phpmyadmin also write mysql_close($con); at the end the bottom of the code Link to comment https://forums.phpfreaks.com/topic/286083-warning-mysql_fetch_row-expects-parameter-1-to-be-resource-boolean-given-in-cxampphtdocsexer10prtsectphp-on-line-20/#findComment-1468374 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.