Advanced Search

Return to Snippet

Revision: 24245
at February 24, 2010 10:32 by Sulcalibur
Initial Code 
<?php

 $querydetails = "
   SELECT wposts.*
   FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
   WHERE wposts.ID = wpostmeta.post_id
   AND wpostmeta.meta_key = 'readmoretext'
   AND wpostmeta.meta_value = 'Go check this out'
   AND wposts.post_status = 'publish'
   AND wposts.post_type = 'post'
   ORDER BY wposts.post_date DESC
 ";

 $pageposts = $wpdb->get_results($querydetails, OBJECT)

 ?>
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Custom Loop/Query Based on Custom Fields

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
wordpress

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP