Advanced Search

Return to Snippet

Revision: 55286
at February 1, 2012 09:55 by ninacess
Initial Code 
SELECT * FROM wp_users, wp_posts WHERE wp_users.ID = wp_postts.post_author AND wp_posts.post_type = 'post' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.post_date DESC LIMIT 10
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Select wp_users and wp_posts to retrieve data from both tables in order to display post title, post date, author name with gravatar (gravatar isn't listed in this code)
Note: probably not idea solution, but it's one of many fixes

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Wordpress Display Recent Authors of Posts

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, wordpress

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL