WordPress.org

Support

Support » Plugins and Hacks » Proper Syntax To Search Table and Display Results

Proper Syntax To Search Table and Display Results

  • jlcoleman71
    Member

    @jlcoleman71

    The plugin is properly installed and I can return a basic query for an entire table……..I’m stuck on how to query the table and only return specific results.

    For example, I have businesses listed in the table, with a “city” field……I would like to query the table and return only entries that match a specific city, like “Boston” or “Dallas”.

    Any input would be appreciated……nice app!

    http://wordpress.org/plugins/abase/

Viewing 7 replies - 1 through 7 (of 7 total)
  • lbentkower
    Member

    @lbentkower

    You will need to use the Where clause in your select statement. This will enable you to specify the city or cities of interest.

    jlcoleman71
    Member

    @jlcoleman71

    Thanks….would you be able to show me an example with the where clause included?

    Here’s an example, I know this won’t filter, I tried…

    [abase SELECT * FROM table=”wp_raw_data” WHERE city=’Boston’]

    jlcoleman71
    Member

    @jlcoleman71

    Ok, I can query the table listed below and only show the 2 columns listed….any help on adding the Where clause to pull only listings for a specific city, like “Boston” or “Miami” would be appreciated.

    [abase table=”wp_raw_data” columns=”Name,City”]

    lbentkower
    Member

    @lbentkower

    I am not sure, but try City rather than city

    dipeshthetime
    Member

    @dipeshthetime

    Can someone please help. I am also trying to use the where statement. What would be the format of this?

    brandon.amey
    Member

    @brandonamey

    Having the same issue! Has anyone found a solution to this?

    esmi
    Forum Moderator

    @esmi

    If you require assistance then, as per the Forum Welcome, please post your own topic instead of tagging onto someone else’s topic.

    I am now closing this 5 month old topic as it references an older version of WordPress.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Proper Syntax To Search Table and Display Results’ is closed to new replies.