spoco Posted November 19, 2008 Share Posted November 19, 2008 Hello. I am trying to get the results of a query to post in a clean format with a header row, etc. I have had no problems getting the data to post, but trying to place it in a formatted table is giving me problems. I am new to PHP/MySQL - any help would be appreciated. <html> <head> <title>View Evaluations</title> <style type="txt/css"> td { width: 200px; background-color: #ccc; } table { width: 700px; border: none; } th { font-weight: bold; text-align: center; } </style> <style type="text/css"> <!-- .style8 {color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-size: 12px; } .style9 { font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 24px; } --> </style> </head> <body> <?php require_once("databaseconn.php"); ?> <?php mysql_select_db('training', $databaseconn) or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM evaluation'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; ?> </div> <p align="center"><span class="style9">Evaluations</span></p> <table width="648" height="157" border="0" align="center"> <tr> <td height="37" bgcolor="#0000FF"><div align="center"><span class="style8">1a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">1b</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">1c</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">2a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">2b</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">2c</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">3a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">4a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">5a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">6a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">7a</span></div></td> <td bgcolor="#0000FF"><div align="center"><span class="style8">8a</span></div></td> </tr> <tr> <td><div align="left"><?php echo $col_value" ?></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> <td><div align="left"></div></td> </tr> </table> <p> </p> </body> <title>View Evaluations</title></html> Link to comment https://forums.phpfreaks.com/topic/133358-having-problems-displaying-data-in-clean-format/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.