SHOW:
|
|
- or go back to the newest paste.
| 1 | $query = $this->db->get('book_bookings');
| |
| 2 | $this->firephp->log($this->db->last_query(), 'getBookings'); | |
| 3 | $this->firephp->log($query, 'q'); | |
| 4 | $bookings = $query->result(); | |
| 5 | //$bookings = $query->result_array(); | |
| 6 | - | $this->firephp->log($bookings, 'bookings'); |
| 6 | + | $this->firephp->log($bookings, 'bookings'); |
| 7 | ||
| 8 | SELECT * FROM (default_book_bookings) JOIN default_book_booking_type ON default_book_bookings.typeId = default_book_booking_type.typeId JOIN default_book_orders ON default_book_bookings.orderId = default_book_orders.id WHERE `start` >= 1339502400 AND `start` <= 1339545600 AND `default_book_orders`.`status` != 'pending' ORDER BY start desc |
