請問這段sql語法要如何改成ci可以用的呢

elfkid

$query = "select psku, pname, pcost, pprice, pskulist from products where pskulist <> ''";
$result = mysql_query($query);
while($row = mysql_fetch_row($result)) {
        $query2 = "select sum(pprice) from products where psku in ($row[4])";
}
請問這段sql語法要如何改成ci可以用的呢

moorland

试试这样.

$this->db->select('psku, pname, pcost, pprice, pskulist');
$this->db->where('pskulist <>', '');
$query = $this->db->get('products');

$row4 = $query->row(4);
foreach ($query->result() as $row)
{
        query2 = "select sum(pprice) from products where psku in ($row4)";
}

paleapple

$this->load->database();
$this->db->select('psku', 'pname', 'pcost', 'pprice', 'pskulist');
$this->db->from('products');
$this->db->where('pskulist<>', '""');
$query = $this->db->get();
$result = $query->result(‘array');
$result2 = array();
foreach($result as $res)
{
   $sql = 'select sum(pprice) from products where psku in('.$res['pprice'].')';
   $query = $this->db->query($sql);
   $result2[] = $query->result('array');
}
print_r($result2);

仅供参考：）

gdtv

直接：
$query = "select psku, pname, pcost, pprice, pskulist from products where pskulist <> ''";
$result  = $this->db->query($query);
......
......

rirny

select * from table where (a=1 or b=2) and c=1
这种有好建议么