<? include ( 'nav.php' ); ?> 



this has been changed again!!! <br>

<? 

$username="www";
//$password="password";
$database="crystals";

mysql_connect(localhost,$username);
@mysql_select_db($database) or die( "Unable to select database");


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

$num=mysql_numrows($result);

echo "<p>$num results found</p>";

$i=0;
while ($i < $num)
{
    echo mysql_result($result,$i,"id");
    echo "----------";
    echo mysql_result($result,$i,"name");
    
    $i++;
}



mysql_close();

?>
