Programmiererforum

+-------+-------------+------------+
| id    | coupon_code | Barcode    |
+-------+-------------+------------+
| 1     | COUPON02    | 12542      |
| 2     | COUPON02    | 11229      |
| 3     | COUPON03    | 11823      |
| 4     | COUPON03    | 47875      |
+-------+-----------+--------------+

< /code>

public function fetch_available_coupon()
{
$coupon_code = $this->uri->segment(3);

$this->db->select('*');
$this->db->from('barcode');
$this->db->group_by('coupon_code', $coupon_code);
$query = $this->db->get();

if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$data[] = $row;
}
return $data;
} else {
return false;
}
}

wie Sie mit CodeIgniter alle mit demselben Wert ausgewählt werden. < /p>
[code]+-------+-------------+------------+
| id | coupon_code | Barcode |
+-------+-------------+------------+
| 1 | COUPON02 | 12542 |
| 2 | COUPON02 | 11229 |
| 3 | COUPON03 | 11823 |
| 4 | COUPON03 | 47875 |
+-------+-----------+--------------+

< /code>

public function fetch_available_coupon()
{
$coupon_code = $this->uri->segment(3);

$this->db->select('*');
$this->db->from('barcode');
$this->db->group_by('coupon_code', $coupon_code);
$query = $this->db->get();

if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$data[] = $row;
}
return $data;
} else {
return false;
}
}
[/code]
In meinem Ergebnis zeigt es nur 1 Zeile nicht die nicht-the-same-Coupon_code-Zeilen.