Did you add the error_reporting(E_ALL); to the top of your document? Are you getting a blank page?
The only thing that comes to mind now as I cant see any obvious errors would be that the Table has no rows.
Does the table exist? Try adding a or die(mysql_error()) on your mysql_query. As well as doing this
echo mysql_num_rows($query);
So your code should look something like this now.
<?PHP
error_reporting(E_ALL); // this should output any errors that come our way
// replace these with your credentials
$server = "localhost";
$user = "saskdiet";
$password = "w6KDheqm";
$database = "saskdiet";
// Connect to Server
mysql_connect($server, $user, $password) or die(mysql_error());
// Select Database
mysql_select_db($database) or die(mysql_error());
// Query the Database
$query = mysql_query("SELECT * FROM `Active Members`") or die(mysql_error()); // replace table with your table name
/* Since I dont know what the table contains I can only guess that i may not have rows thus why the while loop never executes so lets check */
if (mysql_num_rows($query) > 0) //test that its > 0
{
while($row = mysql_fetch_array($query))
{
// put results into an array
echo "Name: " . $row["FirstName"] . "<br>"; // (assuming field name in db is 'name'
echo "Email: " . $row["Address"] . "<br>"; //( assuming field name in db is email)
// and so forth
// close the while loop
}
}
else
echo "There are no records in the Table Active Members";
?>
Since databases arent my speciality can table names have spaces within them?
