Support » Plugins » Hacks » How to query database

  • Hi..

    I have created custom tables in WP database and now want to retrieve the data and display them in the required fields. Like I have one table named flipcountries which have a number of countries name and they are to be displayed in a drop-down field so that user can select one of them.

    I have read about wpdb class and all the references but still not able to display the content.

    Please help how to loop the results..Code I used is:

    global $wpdb;
    $countries = $wpdb->get_results( $wpdb->prepare("SELECT * FROM $wpdb
    foreach ($countries as $country) {
    echo "<option value=country>country</option>";								}

    here country is the second column in flipcountries table.
    I am not sure what should be the code inside foreach loop..

    Any help will be appreciated.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • If the column you want to retrieve from your custom table would be called “country” it should work like this:

    $countries = $wpdb->get_results( 'SELECT country FROM ' . $wpdb->prefix . 'flipcountries', OBJECT_K );
    foreach( $countries as $country ) {
      echo '<option value="' . $country->country . '">' . $country->country . "</option>\n";

    Hi Chris

    Thanks a lot.. it worked..

    You were so helpful.. Really appreciate that.

    You’re welcome. Glad it worked out 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How to query database’ is closed to new replies.