NathanielFisher

The first method doesn’t make any difference: queries without a single quote still work and those with it still don’t. I’ve also tried a number of ways of stripping the single quote from the search query and the data it is searching. But none of them work. For example:

global $wpdb;
$itemName = str_replace("'", "", get_the_title( $ID ));

$results = $wpdb->get_results("SELECT ID FROM $wpdb->posts where $wpdb->prepare($wpdb->posts.post_title) LIKE '$itemName' AND $wpdb->posts.post_status = 'publish' ORDER BY post_title ASC", OBJECT);

But none of them work. I’ve also tried using str_replace within the SQL query but run into problems because of using the single quote within the query.

I was looking for a way for it to be done automatically in the same way that it does when duplicate posts have the same name.

I’m actually trying to add the $post_id to the start of all post_names (partly so I can remove the suffix at the end). So far I’ve got it working on ones where the post_name is a duplicate, but I need it for new posts, too.

So instead of

www.mysite/another-post
www.mysite/another-post-2

it will show

www.mysite/118-another-post
www.mysite/119-another-post
www.mysite/120-a-different-post
www.mysite/121-you-get-the-point

Anyone know how to do this?

Thanks. That’s what I ended up doing. Here it is, if it’s any use to anyone.

$args = array(
    'post_type' => 'post',
	'orderby' => 'meta_value',
	'meta_key' => 'delivery_date',
	'order' => 'ASC',
    'meta_query' => array(
       'relation' => 'AND',
		 array(
              'key' => 'supplier',
              'value' => 'test',
              'compare' => '='
              ),
         array(
            'key' => 'delivery_date',
            'value' => '2015/06/27',
            'compare' => '='
             ),

    )
);

$query = new WP_Query( $args );
if ( $query->have_posts() ) :
    while ($query->have_posts()) : $query->the_post();

             echo $post_id = get_the_ID();
			 echo "---";
			 echo $post_title = get_the_title();
			 echo "---";
			 echo "<br />";

    endwhile;
endif;

Thanks. I did it that way because I’m still getting to grips with SQL and PHP and it seemed more straightforward that way. I just got it working by removing the reference to $wpdb->posts, as I wasn’t using that table anyway. I think the issue might have had something to do with (not properly) traversing the array. Not sure though.

Anyway, this worked.

<?php
global $wpdb;
$results =$wpdb->get_results("SELECT post_id FROM $wpdb->postmeta where  $wpdb->postmeta.meta_value = '2015/06/03' AND meta_key='mymvkey'", OBJECT);

foreach ($results as $result){
printf ($result->post_id);
}
?>

Most people seem to suggest using get_posts for stuff like this. So now I’ve got it working I’ll use your example to help me make sense of that. Thanks again.

I thought it was just a problem with my installation. Isn’t it already available through the dashboard in Taxonomies > General > Enable Categories?

Great. I’m not sure what happened with that code I pasted, but it’s working with yours. Thanks again, Charlie.

Awesome. I see where I went wrong now. Thanks a lot.