- $sql1="select t.id,t.code,t.title as ttitle,t.mode,t.simcontent,t.content,t.createdate,t.editdate,t.brandid,t.saleprice,tp.title,tp.ext,tp.dirname ".
- "from tproduct as t join tpic as tp on tp.productid=t.id ".
- "where t.id<100 order by t.id";
- $arr=$m->query($sql1);
- var_dump($arr);