WordPress.org

Ready to get started?Download WordPress

Forums

SQL Query Help for Displaying Some Data (1 post)

  1. kawestphal
    Member
    Posted 2 years ago #

    I am need of some sql query help. I am looking to retrieve Names from a column as well as another piece of data in this same column. I am then wanting to combine these two values together and display that data (only show the recent 5 names). From my readings, I would be using a UNION ALL within the query ... I've played with the query but need some help to finish it and am hoping someone out there can assist me with that. I am also needing assistance for the echo statement which actually displays the information I want.

    The WordPress site I have setup is an Alumni website and am using BuddyPress. The query above, I want the 5 recent members who have signed up to display in the sidebar along with their graduation year (ex: John Smith - 2002) I have a widget to scroll through the recent members but want to include their graduation year. Since I am using Buddypress, the member sign-up info gets stored in a different table.

    Table info is saved: wp_bp_xprofile_data
    Column with info I want: value

    Picture of Database data

    Here is what I have currently for the sql query:
    $sql = 'SELECTvalueFROMwp_bp_xprofile_dataWHEREfield_id`=3'
    . ' UNION ALL'
    . ' SELECT value FROM wp_bp_xprofile_data WHERE field_id=2';`

    Website: http://alumni.pulaskischoolsonline.org

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.