by Xizor » 13 Apr 2006, 11:19:29
/* No errors? then let's do the search-samba! */
if($this->_ErrorFlag==false)
{
$SearchWords = explode(" ",$this->_SearchKey);
foreach($SearchWords as $Word)
{
foreach($this->_SearchField as $SearchSet)
{
$Query = "SELECT ArtiestID,HGenreID,Genre1ID,Genre2ID,Genre3ID,ArtiestTitel,ArtiestWoonplaats,ArtistRegion,ArtiestLand,PremiumMember FROM ".$SearchSet['Table']." WHERE UPPER(".$SearchSet['Column'].") LIKE '%".strtoupper($Word)."%' ORDER BY PremiumMember DESC,ArtiestTitel ASC;";
$Result = mysql_query($Query) or DIE (mysql_error());