<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[Форум PHP-MyAdmin.RU &mdash; Помогите правильно сформулировать запрос]]></title>
		<link>https://forum.php-myadmin.ru/viewtopic.php?id=1783</link>
		<atom:link href="https://forum.php-myadmin.ru/extern.php?action=feed&amp;tid=1783&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[Недавние сообщения в теме «Помогите правильно сформулировать запрос».]]></description>
		<lastBuildDate>Thu, 10 Jun 2010 00:46:15 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: Помогите правильно сформулировать запрос]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=12352#p12352</link>
			<description><![CDATA[<p>Сработало. Спасибо огромное</p>]]></description>
			<author><![CDATA[null@example.com (tourertt)]]></author>
			<pubDate>Thu, 10 Jun 2010 00:46:15 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=12352#p12352</guid>
		</item>
		<item>
			<title><![CDATA[Re: Помогите правильно сформулировать запрос]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=12344#p12344</link>
			<description><![CDATA[<p><strong>tourertt</strong><br />Попробуйте отредактировать, как показано в коде.</p>]]></description>
			<author><![CDATA[null@example.com (Hanut)]]></author>
			<pubDate>Wed, 09 Jun 2010 17:43:20 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=12344#p12344</guid>
		</item>
		<item>
			<title><![CDATA[Помогите правильно сформулировать запрос]]></title>
			<link>https://forum.php-myadmin.ru/viewtopic.php?pid=12336#p12336</link>
			<description><![CDATA[<p>Попытаюсь выложить тут как можно больше инфо и объяснить что мне нужно... Не судите строго, я новичек в этом деле <img src="https://forum.php-myadmin.ru/img/smilies/sad.png" width="15" height="15" alt="sad" /></p><p>При регистрации на моем вебсайте пользователь заполняет форму где он вводит имя, пароль, дату рождения и т.п. Вконце этой формы он выбирает одну или несколько специализаций. Сразу оговорюсь, если пользователь выбирает только одну специализацию, то все работает ок. Если же больше одной, то возникает пробема.<br />Вот как выглядит запрос при регистрации:</p><p>&nbsp; &nbsp; &nbsp; &nbsp; // Add member details to DB table<br />&nbsp; &nbsp; &nbsp; &nbsp; function addMember()<br />&nbsp; &nbsp; &nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $dbObj;&nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userProfileId = generateRandNumber(3);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $activationCode = generateCode(40);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $DOB = trim($_POST[&#039;date&#039;]).&quot;/&quot;.trim($_POST[&#039;month&#039;]).&quot;/&quot;.trim($_POST[&#039;year&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $nowYear = date(&#039;Y&#039;,time());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $age = $nowYear - trim($_POST[&#039;year&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (count($_POST[&#039;special&#039;]) &gt; 0) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $special = implode(&quot;,&quot;, $_POST[&#039;special&#039;]);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sqlInsert =&nbsp; &nbsp; &quot;INSERT INTO <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;.USERS.&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SET<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; emailId = &#039;&quot;.trim($_POST[&#039;emailId&#039;]).&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; userName = &#039;&quot;.$this-&gt;username.&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; password = &#039;&quot;.base64_encode($this-&gt;password).&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; registerDate = NOW(),<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; usertype = &#039;user&#039;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; profileType = &#039;&quot;.trim($_POST[&#039;profileType&#039;]).&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; activationCode = &#039;&quot;.$activationCode.&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; userProfileId = &#039;&quot;.$userProfileId.&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gender = &#039;&quot;.trim($_POST[&#039;gender&#039;]).&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dob = &#039;&quot;.$DOB.&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; age = &#039;&quot;.$age.&quot;&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; accountType = &#039;free&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; status = &#039;Inactive&#039;,<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span style="color: red">specialise = &#039;&quot;.$special.&quot;&#039; &quot;;</span><br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $res = $dbObj-&gt;query($sqlInsert);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;mysqlInsertId = mysql_insert_id();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;sendActivationCode($activationCode);<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($res) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysqlInsertId;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; }// end of fun</p><p>В бд специализации разделены запятой.</p><p>Далее есть форма поиска пользователей. В ней вводятся параметры типа возраст, пол и т.п. Вконце поиска есть опция искать по специализации. Можно выбрать только одну специализацию чтобы осуществить поиск. Но в случае если пользоваетль указал при регистрации несколько специализаций он не отображается в результате поиска...<br />Вот запрос посылаемый при поиске....</p><p>&nbsp; &nbsp; /**<br />&nbsp; &nbsp; * This fun is call from result page<br />&nbsp; &nbsp; * This fun is use for searching profiles<br />&nbsp; &nbsp; * return 2D array<br />&nbsp; &nbsp; */<br />&nbsp; &nbsp; function ***Search($limit = 0, $page = 0,$forWhat = &#039;&#039;)<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; global $dbObj;<br />&nbsp; &nbsp; &nbsp; &nbsp; $search = &quot;&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; $detail = array();<br />&nbsp; &nbsp; &nbsp; &nbsp; $add = &#039;&#039;;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; if ($limit != 0) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $offset = ($page * $limit) - $limit; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $add = &quot; LIMIT $offset, $limit&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search = &quot; profileType = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;country&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND country = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;country&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;state&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND state = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;state&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;] != &quot;&quot;){<br /><span style="color: #FF6600">// Эту строку убираем&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND specialise = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;]).&quot;&#039; &quot;;</span><br /><span style="color: red">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND specialise LIKE &#039;%&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;]).&quot;%&#039; &quot;; // Здесь делаем выборку с помощью LIKE.</span><br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;] == &quot;Модель&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;ageStart&#039;] &lt; $_SESSION[&#039;sSearch&#039;][&#039;ageEnd&#039;]){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND (age &gt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ageStart&#039;]).&quot;&#039; AND age &lt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ageEnd&#039;]).&quot;&#039;)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;gender&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND gender = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;gender&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;shFeet&#039;] &lt; $_SESSION[&#039;sSearch&#039;][&#039;ehFeet&#039;]){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND (feet &gt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;shFeet&#039;]).&quot;&#039; AND feet &lt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ehFeet&#039;]).&quot;&#039;)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; if($search != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $con1 = &quot; AND &quot;.$search;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;preQuery&#039;] == &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; *<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;.USERS.&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; userType = &#039;user&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;.$con1.&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORDER BY userId DESC&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION[&#039;preQuery&#039;] = $sql;<br />&nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &nbsp; &nbsp; $_SESSION[&#039;preQuery&#039;];<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; $sql = $sql.$add;<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; $dbObj-&gt;query($sql);<br />&nbsp; &nbsp; &nbsp; &nbsp; //echo $sql;<br />&nbsp; &nbsp; &nbsp; &nbsp; if($dbObj-&gt;nf() &gt; 0){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($forWhat == &quot;returnTotal&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $dbObj-&gt;nf();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($dbObj-&gt;next_record()){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $detail[] = $dbObj-&gt;Record;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; return $detail;<br />&nbsp; &nbsp; }//end of fun</p><p>Вот это относится к странице результатов:</p><p>&nbsp; &nbsp; /**<br />&nbsp; &nbsp; * This fun is call from result page<br />&nbsp; &nbsp; * This fun is use for searching profiles<br />&nbsp; &nbsp; * return 2D array<br />&nbsp; &nbsp; */<br />&nbsp; &nbsp; function ***Search($limit = 0, $page = 0,$forWhat = &#039;&#039;)<br />&nbsp; &nbsp; {<br />&nbsp; &nbsp; &nbsp; &nbsp; global $dbObj;<br />&nbsp; &nbsp; &nbsp; &nbsp; $search = &quot;&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; $detail = array();<br />&nbsp; &nbsp; &nbsp; &nbsp; $add = &#039;&#039;;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; if ($limit != 0) {<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $offset = ($page * $limit) - $limit; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $add = &quot; LIMIT $offset, $limit&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search = &quot; profileType = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;country&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND country = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;country&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;state&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND state = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;state&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;] != &quot;&quot;){<br /><span style="color: #FF6600">// Убираем&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND specialise = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;]).&quot;&#039; &quot;;</span><br /><span style="color: red">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND specialise LIKE &#039;%&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;specialise&#039;]).&quot;%&#039; &quot;; // Здесь делаем выборку с помощью LIKE.</span><br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;profileType&#039;] == &quot;Модель&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;ageStart&#039;] &lt; $_SESSION[&#039;sSearch&#039;][&#039;ageEnd&#039;]){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND (age &gt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ageStart&#039;]).&quot;&#039; AND age &lt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ageEnd&#039;]).&quot;&#039;)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;gender&#039;] != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND gender = &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;gender&#039;]).&quot;&#039; &quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;sSearch&#039;][&#039;shFeet&#039;] &lt; $_SESSION[&#039;sSearch&#039;][&#039;ehFeet&#039;]){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $search .= &quot; AND (feet &gt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;shFeet&#039;]).&quot;&#039; AND feet &lt;= &#039;&quot;.trim($_SESSION[&#039;sSearch&#039;][&#039;ehFeet&#039;]).&quot;&#039;)&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; if($search != &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $con1 = &quot; AND &quot;.$search;<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; if($_SESSION[&#039;preQuery&#039;] == &quot;&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &quot;SELECT<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; *<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;.USERS.&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; userType = &#039;user&#039;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;.$con1.&quot;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ORDER BY userId DESC&quot;;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION[&#039;preQuery&#039;] = $sql;<br />&nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $sql = &nbsp; &nbsp; $_SESSION[&#039;preQuery&#039;];<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; $sql = $sql.$add;<br />&nbsp; &nbsp; &nbsp; &nbsp; <br />&nbsp; &nbsp; &nbsp; &nbsp; $dbObj-&gt;query($sql);<br />&nbsp; &nbsp; &nbsp; &nbsp; //echo $sql;<br />&nbsp; &nbsp; &nbsp; &nbsp; if($dbObj-&gt;nf() &gt; 0){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($forWhat == &quot;returnTotal&quot;){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $dbObj-&gt;nf();<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($dbObj-&gt;next_record()){<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $detail[] = $dbObj-&gt;Record;<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; }<br />&nbsp; &nbsp; &nbsp; &nbsp; return $detail;<br />&nbsp; &nbsp; }//end of fun</p><p>Пожалуйста, помогите сделать так чтобы в результатах отображались пользователи которые выбрали несколько специализаций.<br />Заранее благодарен</p><p>P.S Если нужна какая-то еще инфо чтобы решить мою проблему, я ее выложу</p>]]></description>
			<author><![CDATA[null@example.com (tourertt)]]></author>
			<pubDate>Wed, 09 Jun 2010 09:23:30 +0000</pubDate>
			<guid>https://forum.php-myadmin.ru/viewtopic.php?pid=12336#p12336</guid>
		</item>
	</channel>
</rss>
