[ create a new paste ] login | about

Link: http://codepad.org/tZGE9aM2    [ raw code | output | fork ]

PHP, pasted on Jan 29:
1
2
3
4
5
6
7
8
9
10
<?php 
            $sql = 'SELECT SQL_CALC_FOUND_ROWS * FROM dev_posts INNER JOIN dev_posts_destination_geodata AS geo ON (dev_posts.ID = geo.post_id) WHERE (dev_posts.post_status = 'publish' AND dev_posts.post_type = 'destination') AND ( ( (geo.lat BETWEEN '35.1028877837' AND '40.3132252163') AND (geo.lng BETWEEN '-157.416052101' AND '-150.830171403') ) OR ( terms.term_taxonomy_id = '') OR ( parent.parent = '') ) GROUP BY dev_posts.ID ORDER BY dev_posts.post_title ASC LIMIT 0, 10';
        
            global $wpdb;
            $query = $wpdb->get_results($sql, OBJECT);

            print "<pre>";
            print_r($query);
            print "</pre>";
            ?>


Output:
1
2

Parse error: syntax error, unexpected T_STRING on line 2


Create a new paste based on this one


Comments: