Welcome Guest, Not a member yet? Register   Sign In
set sql variable before main query
#1

Is it possible to set sql variable before other queries?(not $this->db->query())

I'd like to do something like this.


PHP Code:
$this->db->query("SET @min_id := (SELECT min_id FROM shop_parameter)");
$this->db->select('item_id');
$this->db->from('products');
$this->db->where('(item_id > @min_id',NULL,FALSE);
$this->db->where(array('item_stat >'=>10));
$query=$this->db->get();
foreach(
$query->result() as $r){
   $products[$r->item_id]=$r; }

Reply


Messages In This Thread
set sql variable before main query - by ash-f - 02-08-2019, 04:02 PM
RE: set sql variable before main query - by ash-f - 02-12-2019, 10:18 PM
RE: set sql variable before main query - by ash-f - 02-12-2019, 10:16 PM
RE: set sql variable before main query - by ash-f - 02-12-2019, 11:33 PM
RE: set sql variable before main query - by ash-f - 02-14-2019, 01:43 PM



Theme © iAndrew 2016 - Forum software by © MyBB