Custom search page

Hello, i need to modify my search page results.

Here is how it actual is – Liz Garden

I need to add an image of the product. I know I have to make the changes to search.php file. I have already build the basic structure for the image. My problem now is I don’t know the way to query the database.

I know the Id of the post, but that record does not hold the link for the picture. That record is of type (post_type) product. I search the wp_post table and I found out that I have a record with post_parent field equal to the id of my product. And that record is of type attachment, and the field quid has the correct link to the product image.

My problem is how to to access this record.

Thx.