1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Wordpress WP_List_Table help

Discussion in 'PHP' started by www.techdo.com, Dec 13, 2020.

  1. #1
    www.techdo.com, Dec 13, 2020 IP
  2. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #2
    Something like this might work, modify this to suit your specific query:

    SELECT ID, field1,
    CASE
    WHEN field1 > 0 THEN "open"
    ELSE "closed"
    END
    FROM table where condition order by ID desc limit 10;
     
    JEET, Dec 14, 2020 IP