Escape Array in SQL. How to do it?

[eluser]behnampmdg3[/eluser]
Would this work?

Code:

$sql = "SELECT
          *
       FROM   ad_have
           INNER JOIN members
             ON members.id = ad_have.member_id
         INNER JOIN au_postcodes
             ON au_postcodes.id = ad_have.suburb
         LEFT OUTER JOIN
          (SELECT ad_ID, ad_have_photo.photo FROM ad_have_photo GROUP BY ad_ID) AS Q_PHOTO  ON Q_PHOTO.ad_ID = ad_have.id
                
       WHERE ad_have.active = 'y'
       AND ad_have.id IN ?
       AND ad_have.weekly_rent > 0
       ORDER BY ad_have.id DESC ";
       $query = $this->db->query($sql, array($ad_ids));