1

I want to run a SELECT query on the Wordpress database and get the results on the screen. Any widget which does it?

4

Have a look at the $wpdb class, it does exactly what you want:

$myrows = $wpdb->get_results( "SELECT id, name FROM mytable" );

Try to avoid SQL queries for basic operations though. WordPress offers you many convenience functions for 80% of the tasks you would every come up with. They provide a nicer interface and preserve upwards compatibility. For example to get posts from the DB you could use the WP_Query class or the get_posts() function.

  • Hello and thanks for your reply. I do not have access to php files right now. I would prefere to do this via a widget. Any widget that offers this? – p.a. Sep 3 '12 at 11:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.