How do i execute different query using loop

<div dir="ltr" style="text-align: left;" trbidi="on"> <b> How do i execute different query using loop  </b><br /> I'm trying to retrieve the number of counts a value have. <br /> Example my I have a field called "find_out_about_us" which stores different value like friends,social_media,search_engine. So lets say i got 5 rows of friends found in that column so my sql query will return me a value of 5. <br /> <br /> Now my problem is... i need to count the value for different values. like i got friends,social_media,search_engine and a lot more.. How do i automate this process?? Instead of keep manually editing the where clause value?<br /> <br /> <blockquote class="tr_bq"> <blockquote class="tr_bq"> $count_query = &quot;SELECT COUNT(`find_out_about_us`) AS counted<br />                        FROM polls<br />                       WHERE `find_out_about_us` =  &#039;friends&#039; &quot;;<br />             <br />        $result = mysqli_query($link, $count_query) or die(mysqli_error($link));<br />        $count_result = mysqli_fetch_array($result); </blockquote> </blockquote> <h3 style="text-align: left;">  How do i execute different query using loop  </h3> </div>

How do i execute different query using loop

 How do i execute different query using loop  I'm trying to retrieve the number of counts a value have. Example my I have a field called "find_out_about_us" which stores different value like friends,social_media,search_engine. So lets say i got 5 rows of friends found in that column so my sql …

Read more »