[Resolved] How can I make this table loop?

[VanPEP]

OK I have this tabel, how can I make it loop until it has shown all available records in the db? ( I cut most out to shorten, but left enough to give you an idea)

<?php
//establish connection
mysql_connect(localhost,dbname,dbpass); //database connection info
mysql_select_db("mydb") or die("Connection to database not available");  //select db or return error

// data query
$result = mysql_query("SELECT * FROM teams");
while ($data = mysql_fetch_array($result))
	$number = $data["phone"];
                $email = $data["email"];

?>
<table width="75%" border="1">
  <tr>
    <td>Phone Number</td>
    <td>Email</td>
 </tr>
  <tr>
    <td><?php echo "$phone"; ?></td>
    <td><?php echo "$email"; ?></td>
  </tr>
</table>

[LordShryku]

<?php 
//establish connection 
mysql_connect(localhost,dbname,dbpass); //database connection info 
mysql_select_db("mydb") or die("Connection to database not available");  //select db or return error 

// data query 
$result = mysql_query("SELECT * FROM teams");

//make sure there are rows returned
$rows = mysql_num_rows($result);
if($rows > 0) { 
	echo "<table width=\"75%\" border=\"1\"> 
  		<tr> 
    		  <td>Phone Number</td> 
    		  <td>Email</td> 
		</tr>"; 
	while($data = mysql_fetch_array($result)) { 
		$number = $data["phone"]; 
		$email = $data["email"]; 
		echo "<tr> 
    			<td>".$phone."</td> 
			<td>".$email."</td> 
		      </tr>";
	}
	echo "</table>";
}

[VanPEP]

When I used that method, I got my table with two colums like it should be, but only the e-mail column was populated, the Phone Number one was empty, any ideas?

[laserlight]

because $phone is used instead of $number

[VanPEP]

arg, Thanks I knew it was something easy i was overlooking 😃