Searching custom table in Wordpress database is stumping me.

Discussion in 'Databases' started by isildur, Oct 3, 2007.

  1. #1
    Hi all. Hope someone has had more luck with something like this than I have. Here is the issue. I added a table to my Wordpress database and have tried various ways to get WP to search it with no luck.

    It's a simple table with a few text fields. Wordpress has built in search, but it only searches the native WP tables like posts, comments, etc.

    I have the runPHP plugin installed and it works fine. I even used it to make query's which display the data from the custom table when its not located in the native WP database. For some reason I cannot make these pages work when the table is located in the WP database.

    The WP search of course does not keyword index my external database nor have I figured out how to get it to index the table I added to the WP database.

    I am stumped. I just want users to be able to search the custom database table from a custom search page in Wordpress. Am I missing something here? I would have posted in the Blogging forum, but I felt that this is more database centric so I am posting here first. Thanks for any help.
     
    isildur, Oct 3, 2007 IP
  2. upl8t

    upl8t Peon

    Messages:
    80
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This is definitely something that will require either a Wordpress plugin, or custom additions made to Wordpress itself.

    Wordpress will only index content added to it's own databases. When you make a post wordpress index's it at that time. When you go to search, it looks up in those search tables for the content.

    To make Wordpress also search your own custom table, you will need a plugin or modifications made to Wordpress.

    Your best bet would be to search for something related to this, or ask in Wordpress specific forums.
     
    upl8t, Oct 22, 2007 IP