Neverside

:| bracket thingy :|

http://www.eg-league.com/phptest.php

im using a basic While loop for this how would i make it work so it just makes 1 table with each person from a mysql table

any help

PHP:

<?php
$event = "TDM";
$result = mysql_query("SELECT * FROM register WHERE catagory='$event'");

while($row = mysql_fetch_array($result)) {
echo ".$row["name"].";
}
?>

its more elaborate then this but this will do :\ i ened help please

___________________

put the table inside your while loop

PHP:

<?php

while(blah){

echo '<table><tr><td>' . $blah . '<td></tr></table>';

}

?>

___________________

| Come join the Purephotoshop.net forums

"bracket thingy" with 2 smilies?

name your thread better next time.

___________________

http://www.philbrodeur.com - Expert PHP Development and Tutorials

god damn

hey Caged do u mean in each part i want to display the info?

___________________

PHP:

<?
$event = "TDM";
$result = mysql_query("SELECT * FROM register WHERE catagory='$event'");
?>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<?
while($row = mysql_fetch_array($result)) {
echo "<tr><td>$row[name]</td></tr>";
}
?>

i think thats right, will insert everything into one table instead of making multiple untidy tables ...... edited coz tags wrong way round :P

___________________

everything we do in life echo's in eternity

hm thats a tun its for this tho

http://www.eg-league.com/phptest.php

u can view the code here :/ its a mess

http://www.eg-league.com/phptest.phps

___________________