Fining order by duplicate IP address - Like to know how many orders came from the same IP

Hi Everyone!
Fining order by duplicate IP address - Like to know how many orders came from the same IP.
I'm trying to get all duplicate IP and display all orders that are coming from the same IP address.

the code below is the one I'm using but is not doing the trick I get an error

when I I can see the list of IP address but I can not get then to displayed.

I only need to display the last 1 to 5 orders from the same IP address that's all.

can anyone help me in solving the problem - I'm not good on db query LOL.

let me know any advice - this is for order list
Opencart 3.0.2.0

Thank you
everyone!

Are you aware of the Fact, that Customer do not always have the same IP Number !?
So, it would not make much sense, trying to make some Listing out of it, I assume ...
Ernie

Try using this code, it will provide the array of top 5 orders from same ip

public function duplicates($ip){
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order WHERE ip = '".$this->db->escape($ip)."' LIMIT 5");
return $query->rows;
}

@ IP CAM, yes we know that but when there are multiple orders from the same IP Address these order can end up as Fraudulent.
by tracking orders via IP we can lower the risk.

@ ostechnologies,

Thank you I will try that, by Limited to 5.

Thank you for your help and advice.