How To Check If A User Purchased An Item On The Product Page

General General Questions
1

I want to show this message on the product page

{if ordered}You bought this item{/if} view order

2

make a request to db using two tables

- cscart_order_details (check product_id here)

- cscart_orders (check user_id here)

3

How?

4
{$previous_order = db_get_field("SELECT count(od.product_id) FROM ?:orders AS o LEFT JOIN ?:order_details AS od ON od.order_id=o.order_id AND od.product_id=?i WHERE o.user_id=?i", $product_id, $user_id}
{if $previous_order}you purchased this{/if}
I tried this it didn't work, how can i make it work and how can i get the url of the ordered item in the product page? thanks
5

So do you receive any error or empty result for this request? Please make sure that $product_id and $user_id variables are not empty

6

Yes, can you give me the snippet for the db query to check if the buyer has purchased it before and the link to the order? Thanks