[SOLVED] Making tables with sql data.

[$username]

Hello Ladies and Gents,

    I have a new issue.

 

I have a piece of code that throws my tables off.

 

while($row = mysql_fetch_array($query)) {
echo "<tr>";
echo("<td><a href=\"updateinfo.php?ID=" .  $row["ID"] . "\" title=\"".$row["ID"]."\">" . $row["ID"] .  "</a><td>"); 
echo "<td>".$row['FirstName']."</td>";
echo "<td>".$row['LastName']."</td>";
echo "<td>".$row['AddressStreet']."</td>";
echo "<td>".$row['AddressCity']."</td>";
echo "<td>".$row['AddressState']."</td>";
echo "<td>".$row['AddressZip']."</td>";
echo "<td>".$row['Paid']."</td>";
echo "<td>".$row['Amount']."</td>";
echo "<td>".$row['CaseNotes1']."</td>";
echo "<td>".$row['CaseNotes2']."</td>";
echo "<td>".$row['CaseNotes3']."</td>";
echo "<td>".$row['CaseNotes4']."</td>";
echo "<td>".$row['OtherInfo']."</td>";
echo "<td>".$row['ServBy']."</td>";
echo "<td>".$row['ClientName']."</td>";
echo "<td>".$row['County']."</td>";
echo "<td>".$row['ServDate']."</td>";
echo "</tr>";
}

?>

 

When I take out the link generator on the second line, then my tables line up. When the 3 lines is in there is throws everything off.

 

echo("<td><a href=\"updateinfo.php?ID=" .  $row["ID"] . "\" title=\"".$row["ID"]."\">" . $row["ID"] .  "</a><td>"); 

 

Here is a pic of what it looks like.

 

 

When I don't have that code in there it looks like this.

 

echo "<td>".$row['ID']."</td>";

 

 

Is there something I can do that would make the code work with in one table.

 

Thanks,

Brett

 

 

 

[marcus]

You miss ended the table data cell. You ended it with <td>, not </td>

[pocobueno1388]

Beat to it

 

Your not closing the <td>

 

Change:

echo("<td><a href=\"updateinfo.php?ID=" .  $row["ID"] . "\" title=\"".$row["ID"]."\">" . $row["ID"] .  "</a><td>"); 

 

To:

echo("<td><a href=\"updateinfo.php?ID=" .  $row["ID"] . "\" title=\"".$row["ID"]."\">" . $row["ID"] .  "</a></td>"); 

[$username]

Well you guys nailed that on the head.

 

Thanks.

Brett