Everything works with no errors.
When looking at the page, the inner join doesn't seem to work.
pupcolor remains the colorID and not the color
Any help would be appreciated
global $pageObject;
$data = $pageObject->getCurrentRecord();
$sql = "SELECT
pups.pupid,
pups.pupgender,
pups.pupprice,
pups.pupsold,
pups.pupcolor,
color.colorID,
color.color
FROM pups
INNER JOIN color on pups.pupcolor = color.colorID where breeding =".$data["breedingid"]."";
$rslitter = CustomQuery($sql);
echo "<table width='100%' border='1' bordercolor='#C0C0C0' cellpadding='5' >";
echo "<tr>";
echo "<td style='padding: 5px 10px 5px 5px;'> Gender</td>";
echo "<td style='padding: 5px 10px 5px 5px;'> Color</td>";
echo "<td style='padding: 5px 10px 5px 5px;'> Price</td>";
echo "<td style='padding: 5px 10px 5px 5px;'> Status</td>";
echo "</tr>";
while($data1=db_fetch_array($rslitter))
{
if ($data1["pupgender"]==1)
echo "<td style='padding: 5px 10px 5px 5px;'> Male <a href=pups_view.php?editid1=".$data1["pupid"]. ">( view )</a></td>";
else
echo "<td style='padding: 5px 10px 5px 5px;'> Female <a href=pups_view.php?editid1=".$data1["pupid"]. ">( view )</a></td>";
echo "<td style='padding: 5px 10px 5px 5px;'> ". $data1["pupcolor"]."</td>";
echo "<td style='padding: 5px 10px 5px 5px;'> ". $data1["pupprice"]."</td>";
if ($data1["pupsold"]==1)
echo "<td style='padding: 5px 10px 5px 5px;'> <font color='red'><b>SOLD</b></font></td></tr>";
else
echo "<td style='padding: 5px 10px 5px 5px;'> Available</td></tr>";
}
echo "</table>";
