Get published posts and pages?

Don’t use pure SQL if you don’t have to. WordPress provides a useful and relatively solid class for retrieving post data. Use it.

$args = array(
  'post_type' => array('post','page'),
  'post_status' => 'publish',
  'posts_per_page' => -1,
  'ignore_sticky_posts' => true,
);
$qry = new WP_Query($args);
// Show post titles
foreach ($qry->posts as $p) { 
    echo $p->post_title; 
}

Reference:
http://codex.wordpress.org/Class_Reference/WP_Query

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. what is the way to see the currently executing query in wordpress?
  3. Fetch array with $wpdb
  4. $wpdb->last_error doesn’t show the query on error
  5. Theoretical Multi-Server WordPress Setup with Shared Users
  6. Delete/replace img tags in post content for auto published posts [closed]
  7. What does wp_update_post() do that the $wpdb class does not?
  8. $wpdb is get_results escaped
  9. wpdb-> not adding prefix to custom table
  10. WordPress insert NOW() in TIMESTAMP column returns all zeros
  11. $wpdb prepare issue with mysql DATE_FORMAT
  12. How-To: wpdb Insert Record With Date
  13. How to pass NULL in where array for $wpdb->update
  14. Get random row from custom table
  15. store custom WP table names in a global variable
  16. wpdb prepare: passing varible number of fields as second argument
  17. I am not understandinhg $wpdb->prepare correctly
  18. How to save html and text in the database?
  19. XOR functionality for meta_query
  20. Using WPDB class
  21. WPDB Update using Conditional Arrays
  22. How can I migrate mysql_fetch_array to $wbpdb?
  23. What is _transient_random_seed for?
  24. create drop down menu in theme customizer from custom db
  25. wpdb get_results() and prepare when to use prepare?
  26. Syntax for $wpdb->prepare when searching in two columns
  27. Foreach loop using $wpdb not results from rows
  28. How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
  29. How to Instantiate wpdb Object in New File
  30. How do you build a wpdb query dynamically?
  31. Would this WPDB setup result in potential race conditions?
  32. How to update a row in a table in WordPress
  33. What’s the proper way to add users to my site in order to test things?
  34. Optimizing WordPress Queries – Removing Group By ID
  35. External DB Connection [closed]
  36. Codex: Database Description: meaning of Cardinality
  37. Code only works every other time its run
  38. WordPress is trimming leading 0s
  39. Can’t pass variable in wordpress wpdb->get_results
  40. WordPress db prepare
  41. How do I count columns on a custom WPDB query?
  42. how to get db values without using an loop with wpdb->get_results()
  43. Custom SQL query ORDER BY term_order
  44. Trouble inserting string containing quotations marks with wpdb in save_post hook
  45. How to run wp_insert_post() & wpdb on the background?
  46. Trying to get variable from WP table and toggle its value
  47. Set MySQL variables in WPDB
  48. get_results query with accent
  49. Save data from a checkbox to a wpdb array
  50. How to prepare an array of values with $wpdb
  51. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  52. WP-PostRatings: list current user’s rated posts
  53. $wpdb->insert() doesnt work anymore
  54. $wpdb query outputs php code instead of executing it
  55. WPDB Join with custom table
  56. wpdb query not working
  57. Where can I see MySQL hostname and port for wp-config.php
  58. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  59. Using “->” in a page to exceute $wpdb query gives error
  60. Why is this $wpdb query looping 5 times?
  61. wpdb query not returning results containing single quotes
  62. duplicate entries in database while using save_post or wp_insert_post
  63. Exclude specific terms from all queries using posts_where or something similar
  64. $wpdb->get_results not returning an array
  65. query a newly created table using $wpdb
  66. Get all sticky posts from one user through user ID
  67. WPDB Query Question with Category Only
  68. wpdb result arrray inside an array
  69. $wpdb->num_rows doesn’t work
  70. How can I change my meta_query to SQL wpdb query?
  71. How capturate wpdb exceptions?
  72. Limit left join
  73. “This message was added in version X” showing a later version than current one
  74. Get records from Formidable Table using $wpdb->get_col
  75. Prepare WPDB with meta key and meta value
  76. How to get row value from wpdb
  77. I am using wpdb but it not working perfectly.but if I dont use form data its work
  78. wont add form details to database or send me mail
  79. Get last element from wpdb as a string
  80. Missing argument 2 for wpdb::prepare() [duplicate]
  81. wpdb->update update the entire table instead of one row
  82. WPDP related functions look to work but they don’t
  83. Save customizer default values to DB on theme activation
  84. Plugin with connection to database – Single function
  85. Alter the main search query to search posts by coauthor user name
  86. Update all fields of table with ON DUPLICATE KEY UPDATE command
  87. WordPress – wpdb query does not list same result as sql query
  88. Protect custom form from SQL injection
  89. why nl2br() is adding an extra ?
  90. How to add more custom fields in user meta table simultaneously
  91. wpdb->update error
  92. get unserialized array without using get_option()
  93. SQL Query to select post title & post ID from a particular category
  94. Create Table Failed Column Date DateType
  95. Using $wpdb to update current post
  96. Checking if meta_value exists for any user
  97. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  98. DBDelta: “table doesn’t exist” for a table that was just created
  99. query using wpdb in wordpress gets me no result
  100. WP Recommended Table Exclusions?