I posted this in the wrong forum earlier, so I am reposting it here.
I\'ve been pulling my hair out over this for about a week now. I\'m trying to have the search pull data from two different tables...sort of like if it isn\'t in one table, then search the other. I\'m stuck. Below is what I have so far. Any help would be greatly appreciated. I don\'t know where else to go from here. Thanks!
Laura
$database[0][\'table\'] = array(\'products, tas\'); / The table in database to search. /
$database[0][\'tableAssoc\'] = \'products.ID=tas.ID\'; / If multiple tables listed, is used to join the tables. See INSTALL. /
$database[0][\'searchField\'] = array(\'products.collection\' or \'tas.collection\', \'products.style_number\', \'tas.style_number\', \'products.style_name\', \'tas.style_name\', \'products.release_date\', \'tas.release_date\', \'products.description\', \'tas.description\', \'products.retail_price\', \'tas.retail_price\', \'products.date_retired\', \'tas.date_retired\', \'products.picture_name\', \'tas.picture_name\', \'products.picture_thumb\', \'tas.picture_thumb\'); / The fields to search. /
$database[0][\'returnField\'] = array(\'products.collection\' or \'tas.collection\', \'products.style_number\' or \'tas.style_number\', \'products.style_name\' or \'tas.style_name\', \'products.release_date\' or \'tas.release_date\', \'products.description\' or \'tas.description\', \'products.retail_price\' or \'tas.retail_price\', \'products.date_retired\' or \'tas.date_retired\', \'products.picture_name\' or \'tas.picture_name\', \'products.picture_thumb\' or \'tas.picture_thumb\'); / Fields returned from db. Can be used to sub into link, url and desc. /
