(11-11-2019, 07:48 PM)php_rocs Wrote: @acebay,

When you execute the query what messages are you seeing?  What does the generated query look like?  Have you tried query binding ( https://codeigniter.com/user_guide/database/queries.html?highlight=query#query-bindings )?

(11-12-2019, 03:12 AM)Chivinsdev Wrote: Try this one I hope it will help you get what you are looking for.

in your controller.

Either you autoload the database in autoload file or you load it to the controller straight by

PHP Code:

$this->load->database(); // within the controller but I prefer autoload 


in your model just continue with

PHP Code:

public function searchListing($data, $location) {
    $q = $this->db->select('*, ABS( post_code - '.$location.') AS distance')
         ->from('list_data')
         ->like('business_name', $data)
         ->order_by('distance')
         ->limit(6)
         ->get()
         ->result();
    return $q;
} 


I used the chaining method which is the shorter method. So try it I hope it will help you.
If you are facing more problem and confused let me know either you private message me or drop your problem here. I am here to help

(11-12-2019, 09:27 AM)Piotr Wrote:

PHP Code:

Easiest way:

$q = $this->db->query("SELECT *, ABS( post_code - 2015 ) AS distance FROM list_data WHERE business_name LIKE '%cash%' ESCAPE '!' ORDER BY distance LIMIT 6");

print_r($q->result()); 


(11-12-2019, 03:49 PM)acebay Wrote:

(11-12-2019, 09:27 AM)Piotr Wrote:

PHP Code:

Easiest way:

$q = $this->db->query("SELECT *, ABS( post_code - 2015 ) AS distance FROM list_data WHERE business_name LIKE '%cash%' ESCAPE '!' ORDER BY distance LIMIT 6");

print_r($q->result()); 


Hi, @Piotr thank you for your reply, you forgot that 2015 and '%cash%' is coming from input fields so you can treat it as a string. Please look at the solution from @Chivinsdev, his solution is correct.