1、先定义sql语句再查询

<?php
    $zc_sql = "SELECT a.products_image as pImg,a.products_model as pNo,b.products_name as pName FROM " . TABLE_PRODUCTS . " a," . TABLE_PRODUCTS_DESCRIPTION . " b where a.products_id=38 and a.products_id=b.products_id";
    $zc_rst = $db->Execute($zc_sql);
?>

2、查询结果

<?php echo $zc_rst->fields['pNo'];?>