daniel0816 Posted September 3, 2013 Share Posted September 3, 2013 I am trying to retrieve all the data from the Job Status table and display it in an html table. This is the code I have, I get the following error: Parse error: syntax error, unexpected end of file <html><body><?phperror_reporting(E_ALL);$connect = mysql_connect("dbinfo", "dbinfo", "dbinfo");//select databasemysql_select_db("dbinfo", $connect); $select = "SELECT * FROM JobStatus";$result = mysql_query($select);if($result){?> <table border="2"> <thead> <tr> <th>Job Status ID</th> <th>Job Reference Number</th> <th>Job Status</th> </tr> </thead> <tbody> <?php if(mysql_num_rows($result)==0) { echo '<tr><td colspan="4">No Rows Returned</td></tr>'; } else { while($row = mysql_fetch_assoc($result)) { echo "<tr> <td>{$row['JS_ID']}</td> <td>{$row['J_RefNum']}</td> <td>{$row['JS_Status']}</td> </tr>\n"; } ?> </tbody> </table> <?php};?></body></html> Thanks again Quote Link to comment https://forums.phpfreaks.com/topic/281812-retrieve-all-data-from-a-table/ Share on other sites More sharing options...
PravinS Posted September 3, 2013 Share Posted September 3, 2013 first remove semi colon ( from last closing bracket and there is no closing bracket for first if condition if($result) also use CODE tags when you post any code so it can be viewed properly Quote Link to comment https://forums.phpfreaks.com/topic/281812-retrieve-all-data-from-a-table/#findComment-1447947 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.