Anekola,
Could you please make the entire php file available? I’ve done as you suggested, to version 1.1 of the plugin. Based on your instructions, it didn’t make sense to make the changes to version 1.5 of the plugin.
I’m using WP2.3.1 and am only getting SQL errors. For example, when I’ve used:
<?php c2c_get_random_posts(1, "%post_content%", "74"); ?>
(ie to get one random post from category 74, showing the post’s content), I get:
WordPress database error: [Unknown column 'wp_term_relationships.term_taxonomy_id' in 'on clause']
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)WHERE wp_posts.post_date <= '2007-11-19 16:55:55' AND ( wp_posts.post_status = 'publish' OR wp_posts.post_status = 'sticky' ) AND wp_posts.post_password = '' AND ( wp_term_relationships.term_taxonomy_id = '74' ) GROUP BY wp_posts.ID ORDER BY rand() DESC LIMIT 0, 1
(I’ve never posted code before so hopefully that worked).
Again, maybe seeing the full, altered file will reduce confusion?
Thanking you heaps in advance!