论坛 › CodeIgniter 问答求助 › 請問這段sql語法要如何改成ci可以用的呢

elfkid 发表于 2009-4-22 21:17:15

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

$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)";
}
請問這段sql語法要如何改成ci可以用的呢

moorland 发表于 2009-4-22 22:27:49

试试这样.

$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 发表于 2009-4-22 22:30:05

$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 发表于 2009-4-23 01:55:22

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

rirny 发表于 2009-4-30 16:48:55

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

查看完整版本: 請問這段sql語法要如何改成ci可以用的呢