Not Able to view Table Data in Menu Item

  • Resolved aatishsingla

    (@aatishsingla)


    8 years, 10 months ago

    Hi,

    I have used the code

    ——-

    if(function_exists(‘add_db_table_editor’)){

    add_db_table_editor(array( ‘title’=>’Coupon Feed’, ‘table’=>’wp_ap_coupon’, ‘sql’=>’SELECT * FROM wp_ap_coupon ORDER BY wp_ap_coupon’ ));

    }
    ———

    in my functions.php file.
    The Table is not visible in the Coupon feed menu
    It just shows up a blank space which is not editable.

    Please guide how to view and add data to the existing table which i have added

    Thanks

    https://www.ads-software.com/plugins/wp-db-table-editor/

Viewing 1 replies (of 1 total)
  • Plugin Author bobbysmith007

    (@bobbysmith007)

    You have an error in your SQL: Your order by clause is invalid and should reference a column (not just the table name)

    SELECT * FROM wp_ap_coupon ORDER BY wp_ap_coupon[.some_column]

    Cheers,
    Russ

Viewing 1 replies (of 1 total)
  • The topic ‘Not Able to view Table Data in Menu Item’ is closed to new replies.