Thanks for your answer.
It seems that it comes from this part :
array( 'key' => 'prix', 'value' => $prix, 'type' => 'NUMERIC', 'compare' => '<=' ),
Because when I comment this part, the search is faster. But I don’t know how to be more efficient than that…
Concerning the change from LIKE to =, I tried. But nothing appears when I’m using it. Is it possible to use = with CHAR ? Because it’s well stored as “Appartement”, “Maison” or “Local commercial” (and in the search, I have the capitalized word, so strictly the same as it’s stored in database).
In every case, I can’t ask my client to come back to all his products to update them, he will be mad ^^
There will be around 2000 “Programmes” in the DB…
I’ve found another way to do it. Maybe not the best way or the cleanest but hey, it works !
<?php foreach($produits->posts as $id):?> <?php if( have_rows('prix',$id)): ?> <?php /*If Typology AND Price are selected in the search engine */ ?> <?php while( have_rows('prix',$id) ) : the_row();?> <?php if((!empty($_POST['typologie']) && $_POST['typologie'] == get_sub_field('typo_prog')) && (!empty($_POST['prix']) && $_POST['prix'] > get_sub_field('prix_prog'))):?> <a href="<?php the_permalink($id);?>" class="produit col-md-4"> MY CONTENT </a> <?php endif;?> <?php endwhile;?> <?php /*If Typology or price are NOT selected in the search engine */ ?> <?php if(empty($_POST['typologie']) || empty($_POST['prix'])):?> <a href="<?php the_permalink($id);?>" class="produit col-md-4"> MY CONTENT </a> <?php endif;?> <?php endif;?> <?php endforeach;?>
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
2022 was a big year for Advanced Custom Fields, with more capabilities, a new generation of ACF Blocks, a refreshed UI, and a new home. Our year in review post looks at advancements we’ve made and offers a glimpse of the future.— Advanced Custom Fields (@wp_acf) January 6, 2023
© 2023 Advanced Custom Fields.