'; // Is there a posted query string? if (isset ($_POST['queryString'])) { $queryString = trim (addslashes (iconv ('UTF-8', 'windows-1251', strip_tags ($_POST['queryString'])))); $q_row = explode (" ", $queryString); // print_r($q_row); $search = array (); foreach ($q_row as $row) { $search[] = "(catalogs_products.name LIKE '%" . $row . "%' OR catalogs_products.text LIKE '%" . $row . " %' OR catalogs_products.art LIKE '%" . $row . " %' OR catalogs_rubrics.name LIKE '%" . $row . "%' OR catalogs_brends.name LIKE '%" . $row . "%' OR catalogs_modifications.code='" . $row . "')"; } // print_r($search); // Is the string length greater than 0? if (strlen ($queryString) > 0) { $sql = "SELECT catalogs_rubrics.translit as translit2,catalogs_rubrics.name as rubric,catalogs_brends.name as brend,catalogs_products.* FROM catalogs_products LEFT JOIN catalogs_rubrics ON catalogs_rubrics.id=catalogs_products.rubric_id LEFT JOIN catalogs_brends ON catalogs_brends.id=catalogs_products.brend_id LEFT JOIN catalogs_modifications ON catalogs_modifications.product_id=catalogs_products.id WHERE catalogs_products.count_modifications>0 "; // (catalogs_products.name LIKE '%".$queryString."%' OR catalogs_rubrics.name LIKE '%".$queryString."%' OR catalogs_brends.name LIKE '%".$queryString."%') if (count ($search)) $sql .= "AND (" . implode (" AND ", $search) . ") "; $sql .= " GROUP BY catalogs_products.id ORDER BY catalogs_products.id DESC limit 6"; $query = mysql_query ($sql) or die (mysql_error ()); if (mysql_affected_rows () != 0) { // While there are results loop through them - fetching an Object. // Store the category id $catid = 0; while ($result = mysql_fetch_assoc ($query)) { echo '
'; echo ''; echo ''; $name = $result['name']; if (strlen ($name) > 35) { $name = substr ($name, 0, 35) . "..."; } echo "

" . $result['rubric'] . ' ' . $name . '

'; echo "

Êîìïàíèÿ " . $result['brend'] . '

'; echo '

' . $result['cine'] . ' ãðí.

'; /** * $description = $result['desc']; * if(strlen($description) > 80) { * $description = substr($description, 0, 80) . * "..."; * } * * echo ''.$description.'';* */ echo ''; echo '
'; } echo 'Âñå ðåçóëüòàòû ïîèñêà'; } else { echo 'íè÷åãî íå íàéäåíî'; } } else { // Dont do anything. } // There is a queryString. } else { echo 'There should be no direct access to this script!'; } echo '';