roanic Posted February 10, 2014 Share Posted February 10, 2014 (edited) <?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>"; ?> Edited February 10, 2014 by roanic Quote Link to comment 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"; Quote Link to comment Share on other sites More sharing options...
roanic Posted February 10, 2014 Author Share Posted February 10, 2014 (edited) 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 Edited February 10, 2014 by roanic Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.