테스트 사이트 - 개발 중인 베타 버전입니다
SIR
목록으로
이전글 다음글

이런 쿼리문 혹시 가능한가요? 채택완료

그렌트힐 5년 전 조회 2,318
답변 3
목록 

</p>

<p>$sql ="<a href="<a href="http://my5701.gabiadb.com/_gabia/dbadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html" target="_blank" rel="noopener noreferrer">http://my5701.gabiadb.com/_gabia/dbadmin/url.php?url=https://dev.mysql.com/doc/refman/5.5/en/select.html</a>" target="mysql_doc">select</a> xm_round from g5_write_offroad where xm_round = 'onn' AND xm_no <= 10";</p>

<p>$result = sql_query($sql);</p>

<p>$on1 = sql_num_rows($result);</p>

<p>

 

저렇게 해서..xm_no <=10 조건으로 갯수를 구하고 있는데요.

 $on1 : xm_no <=10 까지의 갯수

 $on2 : xm_no <=20 까지의 갯수

 $on3 : xm_no <=30 까지의 갯수...

 

이런식으로 각각 값을 구할수 있나요?

 

 

#query #sql
댓글을 작성하려면 로그인이 필요합니다.

답변 3개

채택된 답변
+20 포인트
H
HappyTank
5년 전

한방에 가져오는 것.

</p>

<p>// $on1 : xm_no <=10 까지의 갯수</p>

<p>// $on2 : xm_no <=20 까지의 갯수</p>

<p>// $on3 : xm_no <=30 까지의 갯수

$sql ="select count(xm_round) AS on1, 0 AS on2, 0 AS on3 from g5_write_offroad where xm_round = 'onn' AND xm_no <= 10   </p>

<p>         UNION ALL

         select 0 AS on1, count(xm_round) AS on2, 0 AS on3 from g5_write_offroad where xm_round = 'onn' AND xm_no <= 20</p>

<p>         UNION ALL

         select 0 AS on1, 0 AS on2, count(xm_round) AS on3 from g5_write_offroad where xm_round = 'onn' AND xm_no <= 30";

 </p>

<pre class="language-php">
<code class="language-php"><span class="token variable">$row</span> <span class="token operator">=</span> <span class="token function">sql_fetch</span><span class="token punctuation">(</span><span class="token variable">$sql</span><span class="token punctuation">);</span>
<span class="token keyword keyword-echo">echo</span> <span class="token double-quoted-string string">"on1 : "</span><span class="token punctuation">.</span><span class="token variable">$row</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'on1'</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token double-quoted-string string">"
"</span><span class="token punctuation">;</span>
<span class="token keyword keyword-echo">echo</span> <span class="token double-quoted-string string">"on2 : "</span><span class="token punctuation">.</span><span class="token variable">$row</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'on2'</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token double-quoted-string string">"
"</span><span class="token punctuation">;</span></code></pre>

<p><code class="language-php"><span class="token keyword keyword-echo">echo</span> <span class="token double-quoted-string string">"on3 : "</span><span class="token punctuation">.</span><span class="token variable">$row</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'on3'</span><span class="token punctuation">]</span><span class="token punctuation">.</span><span class="token double-quoted-string string">"
"</span><span class="token punctuation">;</span></code></p>

<p> </p>

<p>

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

플래토
플래토
5년 전

</p>

<p>

$sql ="select 'on1' type, count(xm_round) cnt from g5_write_offroad where xm_round = 'onn' AND xm_no &lt;= 10</p>

<p>union all </p>

<p>select 'on2' type, count(xm_round) cnt from g5_write_offroad where xm_round = 'onn' AND xm_no &lt;=20</p>

<p>union all</p>

<p>select 'on3' type, count(xm_round) cnt from g5_write_offroad where xm_round = 'onn' AND xm_no &lt;= 30</p>

<p>order by type ";</p>

<p> </p>

<p>$result = sql_query($sql);</p>

<p>while ($row = sql_fetch_array($result)) {</p>

<p>    echo "type : ".$row['type']." : ".$row['cnt']."
";</p>

<p>}</p>

<p> 

 

 

로그인 후 평가할 수 있습니다

댓글을 작성하려면 로그인이 필요합니다.

H
HappyTank
5년 전

</p>

<p>// $on1 : xm_no <=10 까지의 갯수</p>

<p><code class="language-php"><span class="token variable">$sql</span> <span class="token operator">=</span><span class="token double-quoted-string string">"select count(xm_round) from g5_write_offroad where xm_round = 'onn' AND xm_no <= 10"</span><span class="token punctuation">;</span></code></p>

<p> </p>

<p>// $on2 : xm_no <=20 까지의 갯수</p>

<p><code class="language-php"><span class="token variable">$sql</span> <span class="token operator">=</span><span class="token double-quoted-string string">"select count(xm_round) from g5_write_offroad where xm_round = 'onn' AND xm_no <= 20"</span><span class="token punctuation">;</span></code></p>

<p> </p>

<p>// $on3 : xm_no <=30 까지의 갯수...</p>

<p><code class="language-php"><span class="token variable">$sql</span> <span class="token operator">=</span><span class="token double-quoted-string string">"select count(xm_round) from g5_write_offroad where xm_round = 'onn' AND xm_no <= 30"</span><span class="token punctuation">;</span></code></p>

<p> </p>

<p>

로그인 후 평가할 수 있습니다

답변에 대한 댓글 1개

�
그렌트힐
5년 전
아 제가 질문을 잘못했네요...
쿼리문 하나로 각각의 값을 얻을수 있는지 알고 싶었거든요...

소중한 답변 감사드립니다.

댓글을 작성하려면 로그인이 필요합니다.

답변을 작성하려면 로그인이 필요합니다.

로그인