WordPress.org

Ready to get started?Download WordPress

Forums

ABASE
[closed] Proper Syntax To Search Table and Display Results (8 posts)

  1. jlcoleman71
    Member
    Posted 7 months ago #

    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/

  2. lbentkower
    Member
    Posted 7 months ago #

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

  3. jlcoleman71
    Member
    Posted 7 months ago #

    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']

  4. jlcoleman71
    Member
    Posted 7 months ago #

    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"]

  5. lbentkower
    Member
    Posted 7 months ago #

    I am not sure, but try City rather than city

  6. dipeshthetime
    Member
    Posted 2 months ago #

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

  7. brandon.amey
    Member
    Posted 2 months ago #

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

  8. esmi
    Forum Moderator
    Posted 2 months ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic