Why am I getting multiples?

ntlab

Hello everyone,
I am having a bit of a problem. The code below allows me to query a db with some physicians in it. The code works fine until ti gets to the "Description" where it creates a new output for each piece that is in the description such as if the doctor went to Baylor for graduate school and Presbyterian Hospital of Dallas for their Internship, it will creat to complete outputs one with Baylor and one with Presbyterian Hospital but not with both. What am I doing wrong? Thanks for the assitance:

<html>
<head>
<title>Physician Listing</title>
<link rel="stylesheet" type="text/css" href="normal.css">
</head>
<body>
<?php
// Database connection variables
$dbServer = "10.100.0.238";
$dbDatabase = "test";
$dbUser = "";
$dbPass = "";
$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");
$dbQuery = "SELECT LastName,FirstName,Thumbnail,Specialty,Address1,City,State,Zip,Phone,Degree,Description ";
$dbQuery .= "FROM physicians, physicianspecialties, specialties, physicianbiocategories, biocategories ";
$dbQuery .= "WHERE physicians.PhysicianID=physicianspecialties.PhysicianID AND ";
$dbQuery .= "physicians.PhysicianID=physicianbiocategories.PhysicianID AND ";
$dbQuery .= "physicianspecialties.SpecialtyID=specialties.SpecialtyID AND ";
$dbQuery .= "physicianbiocategories.BioCategoryID=biocategories.BioCategoryID AND ";
$dbQuery .= "specialties.Specialty LIKE 'Anesthesiology' ";
$dbQuery .= "ORDER by Specialty ASC";
$result = mysql_query($dbQuery) or die("Couldn't get file list");
$base="http://www.wnj.org";
?>
 
<table width="500" align="center" cellpadding="2" cellspacing="0" border="0">
<?
while($row = mysql_fetch_array($result))
{
print "<tr><td width=\"250\" align=\"center\" class=\"bio\"><img src=\"".$base.$row["Thumbnail"]."\"> ";
print $row["FirstName"];
print " ";
print $row["LastName"];
print " ";
print $row["Degree"];
print "&nbsp ";
print $row["Address1"];
print " ";
print $row["City"];
print ", ";
print $row["State"];
print " ";
print $row["Zip"];
print " ";
print $row["Phone"];
print " ";
print $row["Description"];
print " ";
print "</td></tr>";
}

?>
</table>
</body>
</html>

drawmack

The problem is in your where clause however since your column selection is ambiguious by not telling me which table each thing comes from I can't really help you clear it up.

ntlab

drawmack,

print "<tr><td width=\"250\" align=\"center\" class=\"bio\"><img src=\"".$base.$row["Thumbnail"]."\"> ";
// thumbnail comes from physicians table
print $row["FirstName"];
// firstname comes from physicians table
print " ";
print $row["LastName"];
// lastname comes fom physicians table
print " ";
print $row["Degree"];
// degree comes from physicians table
print "&nbsp ";
print $row["Address1"];
// address1 comes from physicians table
print " ";
print $row["City"];
// city comes from physicians table
print ", ";
print $row["State"];
// state comes from physicians table
print " ";
print $row["Zip"];
// zip comes from physicians table
print " ";
print $row["Phone"];
// phone comes from physicians table
print " ";
print $row["Description"];
// description comes from physicianbiocategories table

thanks for your help.

drawmack

then pull description out of the original query along with this line

$dbQuery .= "physicians.PhysicianID=physicianbiocategories.PhysicianID AND ";

then create another query that just gets the description based on the current physicianid where you echo out the description now.