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 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 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
Archived
This topic is now archived and is closed to further replies.