outputing data from DB into table

[BryonS]

ive read many bits of code on the forums but i dont understand them and cant edit them to work fo rme.. i want a code for something such as a members page..

|Name|EMail|Aim|

|name1|email1|aim1|
|2|2|2|

|3|3|3|

and so forth how can i grab data from database and write it into a table like that??

[cgraz]

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10238121

Check out the part titled how to retrieve and display data from database. If you have any more questions or need more clarification post back here and I'll help you out.

Cgraz

[BryonS]

yah those code helped me a lil id found it before i posted this topic i just dont know who to put it into a table..
[name][email][aim]
1 1 1
2 2 2
3 3 3
4 4 4
5 5 5

[cgraz]

Well, you gotta think ahead a little in order to put the results into a table. This used to seem really confusing when I just learned this, but it's actually quite easy.

The while loop repeats, right? So you don't want to have your table tag inside of the while loop, or else you're going to get as many tables as you have results. You also don't want your </table> tag within your while loop, or you'll have as many of those as you have results.

You want to put your <table> tag before the while loop, and your </table> tag outside of your while loop, in order to put all the results in one table. Your setup would look something like this

echo "<table width=\"600\">\n";

while($row = mysql_fetch_array($query)) {

   echo "<tr>\n";
   echo "<td width=\"200\"><b>Name</b></td>\n";
   echo "<td width=\"200\"><b>Email</b></td>\n";
   echo "<td width=\"200\"><b>AIM</b></td>\n";
   echo "</tr>\n";

   echo "<tr>\n";
   echo "<td width=\"200\">" . $row["name"] . "</td>\n";
   echo "<td width=\"200\">" . $row["email"] . "</td>\n";
   echo "<td width=\"200\">" . $row["aim"] . "</td>\n";
   echo "</tr>\n";

}

echo "</table>\n";

Cgraz