[RESOLVED] Displaying Columns In Tables

hendy

Hi All,

I am currently displaying the contents of a database directly onto a webpage, is there a way i can dispaly it a bit neater, like use a few tables to align the data, what is the best method to do this, currently im just this code:

<?php
mysql_connect("localhost", "root","2233home") or die(mysql_error());
       mysql_select_db("customers") or die(mysql_error());

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

   $num=mysql_numrows($result);

   mysql_close();

   $i=0;

   while ($i < $num) {

   $CustID=mysql_result($result,$i,"CustID");
   $CustNo=mysql_result($result,$i,"CustNo");
   $Name=mysql_result($result,$i,"Name");
   $Address=mysql_result($result,$i,"Address");
   $Day=mysql_result($result,$i,"Day");



echo "$CustID $CustNo $Name $Address $Day<BR>";

$i++;
}


?>

This displays the contents on a webpage but it just looks untidy, is there a way of creating a "html" type table and putting the data into this tabe?

Thanks

obsidian

the easiest way to get what you're after would be something like this:

// added line
echo "<table>\n";

while ($i < $num) {

   $CustID=mysql_result($result,$i,"CustID");
   $CustNo=mysql_result($result,$i,"CustNo");
   $Name=mysql_result($result,$i,"Name");
   $Address=mysql_result($result,$i,"Address");
   $Day=mysql_result($result,$i,"Day");


// changed line
echo "<tr><td>$CustID</td><td>$CustNo</td><td>$Name</td><td>$Address</td><td>$Day</td></tr>\n";

$i++;
} 

// added line
echo "</table>\n";

hope this helps

hendy

I had attempted something similar earlier, but no joy, the code that you suggested dispalys the contents and a long strong accross the page and only returns a new line after about 5 or 6 rows of information, i tried adding a <BR> instead of a \n .

Thanks for the code though!!

hendy

I just noticed something strange, when i view the page, the database is displayed like this:

CustID Cust No Name Address Day

CustID 10001 Iscourt_LTD Ramelton Monday

CustID 10002 Whoriskeys Ramelton Monday

CustID 10003 PJ_McFaddens Ramelton Monday

If i view the source of the page, it tells me that a table has been created, do i have to make the table visible?? This is was it says when i view the source:

<table>
<tr><td>CustID</td><td>Cust No</td><td> Name</td><td>Address</td><td>Day
</td></tr></table>
<table>
<tr><td>CustID</td><td>10001</td><td>Iscourt_LTD</td><td>Ramelton</td><td>Monday
</td></tr></table>
<table>
<tr><td>CustID</td><td>10002</td><td>Whoriskeys</td><td>Ramelton</td><td>Monday
</td></tr></table>
<table>

etc........

Any ideas?

Thanks

hendy

Got it sorted, i had to put in a <border=2> to make it visible, thanks guys