Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Search multiple tables

View all replies to this thread

Search multiple tables

Thread began 7/22/2011 5:44 am by dave315749 | Last modified 7/26/2011 6:31 am by dave315749 | 2995 views | 9 replies

7/22/2011 5:44 amdave315749

Search multiple tables

Looking to search through tables for content, categories, store items, store categories and more..

I have been playing around with joins doing a full join to join the content and categories together. That seemed to work, when i search with data assist if i do a AND + OR, for each title column in each table, it returns only one of the tables. heres the code.

$WADbSearch1->addComparison("title_con","".$_POST['searchbox'] ."","AND","Includes",0);
$WADbSearch1->addComparison("title_cat","".$_POST['searchbox'] ."","OR","Includes",0);

How do i set it up so that when it searches and finds results on each table, it will display the result?

I need to add probably 5 more tables into the mix after i get 2 working..

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.