I can only get my page to grab info out of the first row in a table, phpmyadmin shows me that there are other rows. Did i do something wrong with the mysql_numrows thing?
this is my php code:
<?
$username="kristin";
$password="password";
$database="members";
mysql_connect("localhost","$username","$password");
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM members";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>Database Output</center></b><br><br>";
$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"name");
$email=mysql_result($result,$i,"email");
$position=mysql_result($result,$i,"position");
echo "$name $email $position";
++$i;
}
?>
