$wpdb->prepare for SQL request

[pastacode lang= »php » manual= »%24table_name%20%3D%20%24wpdb-%3Eprefix.%22organismes_prestations_cache%22%3B%0A%24set%20%3D%20%24wpdb-%3Equery(‘SET%20group_concat_max_len%20%3D%202048′)%3B%0A%24query%20%3D%20%24wpdb-%3Eprepare(%22SELECT%20organisme_id%2C%20GROUP_CONCAT(DISTINCT%20formule%20ORDER%20BY%20formule%20ASC%20SEPARATOR%20’_’)%20AS%20formules%20FROM%20%24table_name%20WHERE%20age%20%3D%20%25d%20AND%20langue%20%3D%20%25s%22%2C%20%24age%2C%20%24langue)%3B%0Aif(%24pays%20!%3D%20 »)%7B%0A%09%24cond%20%3D%20%22%20AND%20pays%20IN(%22.implode(‘%2C%20’%2C%20array_fill(0%2C%20count(%24pays)%2C%20’%25s’)).%22)%22%3B%0A%09%24query%20.%3D%20call_user_func_array(array(%24wpdb%2C%20’prepare’)%2C%20array_merge(array(%24cond)%2C%20%24pays))%3B%0A%7D%0Aif(%24duree%20!%3D%20 »%20%26%26%20%24duree%20!%3D%20′—‘%20%26%26%20%24duree%20!%3D%20’Indiff%C3%A9rent’)%7B%0A%09%24cond%20%3D%20%24wpdb-%3Eprepare(‘%20AND%20duree%20%3D%20%25s’%2C%20%24duree)%3B%0A%09%24query%20.%3D%20%24cond%3B%0A%7D%0A%24query%20.%3D%20%22%20GROUP%20BY%20organisme_id%22%3B%0A%24results%20%3D%20%24wpdb-%3Eget_results(%24query)%3B%0A%24count_results%20%3D%20count(%24results)%3B » message= » » highlight= » » provider= »manual »/]