Fretless

I should add that I’d be willing to pay for a working widget if the price was reasonable. I know that it’s a quick and easy job for a skilled coder (which I’m not) to do, so I guess that should keep the cost down. I’d also pay through PayPal if anyone is interested.

Basically I’m looking for the entire Kubrick sidebar made into a working widget. Any takers?

Thanks Zoutesnor, but I keep on getting syntax errors when I try your code. Usually with ‘<‘. Any ideas?

I’m experiencing the same problem. Does anyone have a fix for this yet?

Out of interest, how did you do the feed code Xander?

OK, I think I’ve worked it out now. The “DESC” was in the wrong place. Instead of:

$request = ” SELECT $distinct * FROM $wpdb->posts $join WHERE 1=1″.$where.” ORDER BY ID $limits desc”;

it should be….

$request = ” SELECT $distinct * FROM $wpdb->posts $join WHERE 1=1″.$where.” ORDER BY ID DESC $limits”;

Thanks again for helping me out.

Thanks ifelse, but I get a syntax error when that happens:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘desc’ at line 1]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-10-27 14:23:59’ AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY ID LIMIT 0, 5 desc

Any other ideas?