Problem With WHERE Clause

Problem With WHERE Clause

El Forum
Guest

06-22-2012, 02:39 AM

[eluser]Sanjay Sarvaiya[/eluser]
Try this sql query without using where and or_where_in.

Code:
$query = 'SELECT * FROM products_diamonds WHERE (shape=? AND carat >= ? AND carat <= ? AND (cost BETWEEN ? AND  ?)) OR colour in (?) OR clarity in(?) OR certification_type in(?)';

$query = $this->db->query($query, array($shape, $min_carat, $max_carat, $min_price, $max_carat,$colours,$clarities,$certifications));

Messages In This Thread

Problem With WHERE Clause - by El Forum - 06-22-2012, 01:47 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 01:53 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 02:10 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 02:39 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 03:22 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 03:43 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 04:10 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 04:21 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 06:55 AM

Problem With WHERE Clause - by El Forum - 06-22-2012, 06:50 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:34 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:38 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:50 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 10:56 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 11:13 PM

Problem With WHERE Clause - by El Forum - 06-22-2012, 11:16 PM

Problem With WHERE Clause - by El Forum - 06-23-2012, 02:12 AM