Your prod.ID column isn't listed in the prodsize.ProdSizeID table. That is why there aren't any results showing. I updated the prod_detail.php page to use a LEFT OUTER JOIN so it will still return results when the data is missing from the other table.