Here are the some screen shots - the page didn't produce an error - it just didn't produce a result at all where I put the new code (it's in the main table). Here are some screen shots of the tables and the results.
1. WA_tables.gif are the tables I'm using
2. WA_tables_results are what the pages look like (you'll see the duplicate "Member" on the Profile and Visitor Detail screen shot.
I have this posted on a test URL and would be happy to email you the URL with a login & password if you want to look at it live (I don't want to include that info here).
Here's the old (top) and new (bottom) code (I don't see how to upload the page). This is what produce the double "Member" on the "Visitor Details" (screenshot):
<td class="tableHeader">Access Level:</td>
<td class="tableData"><?php
$query = "SELECT visitors.VisitorGroupID, groups.GroupName ".
"FROM visitors, groups ".
"WHERE visitors.VisitorGroupID = groups.GroupID";
$result = mysql_query($query) or die(mysql_error());
// Print out the contents of each row into a table
while($row = mysql_fetch_array($result)){
echo $row['GroupName'];
echo "<br />";
}
?></td>
</tr>
<tr>
<td><?php
$query = "SELECT visitors.VisitorGroupID, groups.GroupName ".
"FROM visitors, groups ".
"WHERE visitors.VisitorGroupID = groups.GroupID GROUP BY groups.GroupName";
?>