Simply Output; why won't it work???!!

kona72

Hi Everyone,

I have a page that is supposed to just output the entire DB so I can view it. Here is the code

error_reporting(E_ALL); // this should output any errors that come our way 

$DBhost = "xxxxxx";
$DBuser = "xxxxxx";
$DBpass = "xxxxxx";
$DBName = "xxxxxx";
$table = "active_members";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

// Performing SQL query
$query = mysql_query("SELECT * FROM `active_members` ORDER BY `LastName`" )
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

// if records present 
if (mysql_num_rows($result) > 0) 
{ 
// iterate through resultset 
// print title with links to edit and delete scripts 
while($row = mysql_fetch_object($result)) 
{ 
?> 
<table><tr><td width=400><font face="verdana">Membership ID : <? echo $row->MembershipID; ?><br><b>Title : <? echo $row->Title; ?></b><BR>First Name : <? echo $row->FirstName; ?><BR>Middle Name : <? echo $row->MiddleName; ?><BR>Last Name : <? echo $row->LastName; ?><BR>Previous Surname : <? echo $row->Previous Surname; ?>font></td><td>
</td></tr></table> 
<br> 
<font face="verdana"><a href="edit.php?id=<? echo $row->id; ?>">edit</a> | <a 
href="delete.php?id=<? echo $row->id; ?>">delete</a></font> 
<p> 
<? 
} 
} 
// if no records present 
// display message 
else 
{ 
?> 
<font face="verdana">No Members currently available</font><p> 
<? 
} 

// close connection 
mysql_close($connection); 
?> 
<font face="verdana"><a href=""addmember.html">Add new member</a></font>

All I get is a blank page.... Any ideas????

Thanks!!

drew010

$query = mysql_query("SELECT * FROM `active_members` ORDER BY `LastName`" )
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

missing the ; after the $query = ... line.

try adding
ini_set('display_errors', 1);
near your error_reporting line. display_errors is probably off in php.ini if it didnt report that parse error.