www.webdeveloper.com
Results 1 to 2 of 2

Thread: Full text searching questions -- multiple tables - help!

  1. #1
    Join Date
    Nov 2009
    Location
    Oklahoma
    Posts
    8

    Full text searching questions -- multiple tables - help!

    I have 9 tables joined into my search. At the moment I'm using the code below to return the results.

    Code:
    WHERE asmnt_parcel.Account LIKE '{$search}' OR asmnt_parcel.OwnersName LIKE '{$search}' OR asmnt_parcel.ParcelID LIKE '{$search}' OR asmnt_legal.Legal LIKE '{$search}'
    I have more tables that I need to be able to pull records from in a search though, so obviously the above method won't work too well. Thus, I'm trying to do full text searching.

    I can full text search from one table, but when I try to add in a second table to be full text searched from, it won't work.

    This query works perfect:

    Code:
    "SELECT appr_agland.Account, appr_agland.Acres, appr_resident.Account, appr_resident.YearBuilt
     			 FROM appr_agland
     			 LEFT JOIN appr_resident
     			 ON appr_agland.Account=appr_resident.Account
     			 WHERE MATCH (appr_agland.Account) AGAINST('$search')";
    But, as soon as I try to add in the second table, kind of like this query below (note bolded part), it doesn't work:

    Code:
    "SELECT appr_agland.Account, appr_agland.Acres, appr_resident.Account, appr_resident.YearBuilt
     			 FROM appr_agland
     			 LEFT JOIN appr_resident
     			 ON appr_agland.Account=appr_resident.Account
     			 WHERE MATCH (appr_agland.Account) AGAINST('$search') OR MATCH (appr_resident.Account) AGAINST('$search')";
    How can I make it so that I can full text search from multiple tables? Or, is there a better way to search from multiple tables?

    Thanks for any & all help!!
    Qadoshyah

  2. #2
    Join Date
    Nov 2009
    Location
    Oklahoma
    Posts
    8
    Does anybody have any ideas???????

    Please help!
    Qadoshyah

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles