MySQL表联接用于带循环的php动态视图

-1

Table name: acc_type and it's structure id image_1 image_3 1 1.jpg 2.jpg 2 3.jpg 4.jpg 3 5.jpg 6.jpg

Table name: Products and it's structure id_product id_category_default acc_type 1 20 1 2 22 2 3 23 3 4 24 2 5 25 1

$sql = mysql_query("SELECT * FROM pproducts WHERE id_category_default='$id_category_default' ORDER BY id_product DESC 50"); $dynamicList = ''; $productCount = mysql_num_rows($sql); if ($productCount > 0) { while($row = mysql_fetch_array($sql)){ $id_product = $row["id_product"]; $id_category_default = $row["id_category_default"]; $acc_type = $row["acc_type"]; $dynamicList .=''; }else{ $dynamicList = "We have no products listed in our store yet"; }

在这里，我想从acc_type表中获得单独的image_1和image_3，以从产品表中获得单独的product_id。我该怎么办？请帮忙。