[SOLVED] table is not aligned right

[cluce]

can someone tell me how to fix this table thats in the attachment. before I pull all my hair. 

I know I am looping the table border I just dont know how to get it to work outside the loop.

 

here is my code..

<?php
//connect to database
include'db.php';

//get all data from table
$sql = "SELECT * from products";
$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));


//if authorized, get the values
while ($info = mysqli_fetch_array($result)) {
	$ItemNo = stripslashes($info['Item_No']);
	$Man = stripslashes($info['Manufacturer']);
	$Cat = stripslashes($info['Category']);
	$Des = stripslashes($info['Description']);
	$Model = stripslashes($info['Model']);
	$Qty = stripslashes($info['Qty']);
	$Kw = stripslashes($info['Kw']);
	$Hours = stripslashes($info['Hours']);
	$Price = stripslashes($info['Price']);

//create display string
$display_block = "
<table border = '1'> 
<td>".$ItemNo."</td>
<td>".$Man."</td>
<td>".$Cat."</td>
<td>".$Des."</td>
<td>".$Model."</td>
<td>".$Qty."</td>
<td>".$Kw."</td>
<td>".$Hours."</td>
<td>".$Price."</td>
</tr>
</table>";

//displays string with data
echo "$display_block";
}
?>

 

thanks in advacne

 

[attachment deleted by admin]

[wildteen88]

If you mean your columns are not aligning up it is because you are echo'ing a separate table for each row. You'll want to remove the table tags out of the loop:

<?php

//connect to database
include'db.php';

//get all data from table
$sql = "SELECT * from products";
$result = mysqli_query($mysqli, $sql) or die(mysqli_error($mysqli));

$display_block = "<table border=\"1\">\n";

//if authorized, get the values
while ($info = mysqli_fetch_array($result))
{
    $ItemNo = stripslashes($info['Item_No']);
$Man = stripslashes($info['Manufacturer']);
$Cat = stripslashes($info['Category']);
$Des = stripslashes($info['Description']);
$Model = stripslashes($info['Model']);
$Qty = stripslashes($info['Qty']);
$Kw = stripslashes($info['Kw']);
$Hours = stripslashes($info['Hours']);
$Price = stripslashes($info['Price']);

//create display string
$display_block .= "  <tr>
    <td>".$ItemNo."</td>
    <td>".$Man."</td>
    <td>".$Cat."</td>
    <td>".$Des."</td>
    <td>".$Model."</td>
    <td>".$Qty."</td>
    <td>".$Kw."</td>
    <td>".$Hours."</td>
    <td>".$Price."</td>
  </tr>\n";
}

//displays string with data
echo $display_block . '</table>';
?>

[cluce]

yeah. I fixed it .thanks