Heath Atchley Heath Atchley - 1 year ago 88
HTML Question

PHP/HTML Form Display

Can someone tell me what I am doing wrong? The code runs fine, but the result that outputs is weird. It is giving me an extra column.

error_reporting(E_ALL); ini_set('display_errors', 1);
$serverName = "server\sqlexpress";
$connectionInfo = array("Database"=>"mine");
$conn = sqlsrv_connect($serverName, $connectionInfo);
if($conn === FALSE){
die( print_r( sqlsrv_errors(), true));

$sql = 'SELECT id, name, age FROM names';
$records = sqlsrv_query($conn, $sql);


<meta charset="UTF-8">
<title>Heath Data</title>
<table width="600" border="1" cellspacing="1" cellpadding="1">

while ($employee = sqlsrv_fetch_array($records, SQLSRV_FETCH_ASSOC)){
echo "<tr>";
echo "<td>".$employee['id']."<td>";
echo "<td>".$employee['name']."<td>";
echo "<td>".$employee['age']."<td>";
echo "<tr>";



Here is the rersult:
enter image description here

Why the extra column?

Answer Source

Just need to terminate the tags

echo "<tr>";
echo "<td>".$employee['id']."</td>";
echo "<td>".$employee['name']."</td>";
echo "<td>".$employee['age']."</td>";
echo "</tr>";
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download