Create a table for columns instead of individual lines

[hendy]

Hi all, im trying to out the contents of a mysql search to a web page, i can make the table without a problem, its just looks kinda messy as shown in mysql output.jpg that i have attached.

here is the code that im using:

$_Table = $_REQUEST["Cust"];



mysql_connect("localhost", "xxxxxx","xxxxxxxx") or die(mysql_error());
       mysql_select_db("customers") or die(mysql_error());

   $query="SELECT * FROM $_Table";
   $result=mysql_query($query);

   $num=mysql_numrows($result);

   mysql_close();

   $i=0;
echo "<BR>";
echo "<table width=95%, border=2>";
echo "<td width=9%>CustID</td><td width=8%>InvNo</td><td width=15%>Date</td><td width=10%>Qty</td><td width=20%>Product</td><td width=10%>Code</td><td width=10%>exVat</td><td width=10%>Vat</td></tr>";
echo "</table>";
	   while ($i < $num) {


   $CustID=mysql_result($result,$i,"CustID");
   $InvNo=mysql_result($result,$i,"InvNo");
   $Date=mysql_result($result,$i,"Date");
   $Qty=mysql_result($result,$i,"Qty");
   $Product=mysql_result($result,$i,"Product");
   $Code=mysql_result($result,$i,"Code");
   $ExVat=mysql_result($result,$i,"ExVat");
   $Vat=mysql_result($result,$i,"Vat");

echo "<table width=95%, border=2>";

echo "<td width=10%>$CustID</td><td width=13%>$InvNo</td><td width=20%>$Date</td><td width=8%>$Qty</td><td width=25%>$Product</td><td width=10%>$Code</td><td width=12%>$ExVat</td><td width=13%>$Vat</td></tr>";

echo "</table>";
$i++;
}

ive tried moving the code for creating the table but without success can anyone suggest how i can insert and entire column into a table instead of an individual row??

Thanks

[Houdini]

You might want to adjust your percentage values they all add up to 111% and I changed the first row to headers which will center and be bold indtead of td, you can change it back if you want.

echo "<BR>";
echo "<table width=95%, border=2>";
echo "<th width=10%>CustID</th><th width=13%>InvNo</th><th width=20%>Date</th><th width=8%>Qty</th><th width=25%>Product</th><th width=10%>Code</th><th width=12%>exVat</th><th width=13%>Vat</th></tr>";

   $i=0;
   while ($i < $num) {


   $CustID=mysql_result($result,$i,"CustID");
   $InvNo=mysql_result($result,$i,"InvNo");
   $Date=mysql_result($result,$i,"Date");
   $Qty=mysql_result($result,$i,"Qty");
   $Product=mysql_result($result,$i,"Product");
   $Code=mysql_result($result,$i,"Code");
   $ExVat=mysql_result($result,$i,"ExVat");
   $Vat=mysql_result($result,$i,"Vat");

echo "<table width=95%, border=2>";

echo "<td width=10%>$CustID</td><td width=13%>$InvNo</td><td width=20%>$Date</td><td width=8%>$Qty</td><td width=25%>$Product</td><td width=10%>$Code</td><td width=12%>$ExVat</td><td width=13%>$Vat</td></tr>";

echo "</table>"; 

[hendy]

Hi Houdini, thanks for the reply, what you suggested certainly tidys up the output a little but its still not what im lookin for, instead of this:

---

| 4th July 2006 | 12 | Chocolate Sponge | 347521982945893 | 24.95 |

---

| 5th July 2006 | 16 | Chocolate Sponge | 62356234634643| 32.95 |

---

i need it to look something like this:

---

| 4th July 2006 | 12 | Chocolate Sponge | 347521982945893 | 24.95 |
| 5th July 2006 | 16 | Chocolate Sponge | 6235623463464334 | 32.95 |

---

Sorry for the rough lookin tables, but i think it shows what i mean, i want each column to be displayed in its own table, rather than each row in each coumn displayed in a table..

or is this possible, thanks

[Roger_Ramjet]

So move your <table>, </table>, <th> tags outside the while loop and make each row a table row instead of a table ???

While you are at it, get rid of all that tag formatting and move it into CSS where it belongs, Then you can focus on one problem at a time: 1) creating the data output table, 2) making it look nice on the page.

[hendy]

Hi i tried what you suggested, moving the table outside the loop but i cant see how that would work, as it only returns the first row of the database...

while ($i < $num) { 


   $CustID=mysql_result($result,$i,"CustID"); 
   $InvNo=mysql_result($result,$i,"InvNo"); 
   $Date=mysql_result($result,$i,"Date"); 
   $Qty=mysql_result($result,$i,"Qty"); 
   $Product=mysql_result($result,$i,"Product"); 
   $Code=mysql_result($result,$i,"Code"); 
   $ExVat=mysql_result($result,$i,"ExVat"); 
   $Vat=mysql_result($result,$i,"Vat"); 

$i++;
}

echo "<table width=95%, border=2>"; 

echo "<td width=10%>$CustID</td><td width=13%>$InvNo</td><td width=20%>$Date</td><td width=8%>$Qty</td><td width=25%>$Product</td><td width=10%>$Code</td><td width=12%>$ExVat</td><td width=13%>$Vat</td></tr>"; 

echo "</table>"; 

[Roger_Ramjet]

I said move tha table TAGS, not the whole table.

echo "<table width=95%, border=2>";

while ($i < $num) {


   $CustID=mysql_result($result,$i,"CustID");
   $InvNo=mysql_result($result,$i,"InvNo");
   $Date=mysql_result($result,$i,"Date");
   $Qty=mysql_result($result,$i,"Qty");
   $Product=mysql_result($result,$i,"Product");
   $Code=mysql_result($result,$i,"Code");
   $ExVat=mysql_result($result,$i,"ExVat");
   $Vat=mysql_result($result,$i,"Vat");


echo "<td width=10%>$CustID</td><td width=13%>$InvNo</td><td width=20%>$Date</td><td width=8%>$Qty</td><td width=25%>$Product</td><td width=10%>$Code</td><td width=12%>$ExVat</td><td width=13%>$Vat</td></tr>";


$i++;
}

echo "</table>";