categoryid 分类IDselect a.*,b.categoryname from product a left join category b on a.categoryid = b.categoryid
categoryid 分类IDselect a.*,b.categoryname from product a left join category b on a.categoryid = b.categoryid
select a.*,b.class from tablea a,tableb b where a.id = b.id
select product.id,product.name,product.X,class.id,class.name from product,class where product.classID=class.id 希望能帮上你
$sql="select proclass.b_name,proclass.s_name,prolist.c_id,prolist.p_id,prolist.p_name,prolist.p_img,prolist.p_content,prolist.iscomm from proclass,prolist where prolist.id=".$_GET['id']." and prolist.c_id=proclass.id";
希望能帮上你