Finding and printing most common value within MySql database using PHP -
i have code retrieve values, don't know how return modal value in array.
$stuff = "select count (subjectno) subjectallocation"; $direct = mysqli_query($link, $stuff);  while($row = mysqli_fetch_array($direct)){     echo $row['count (subjectno)'];     echo "<br />"; } i understand performing count, want define base start from.
here 1 method getting "mode" -- statistical term common value:
select subjectno subjectallocation group subjectno order count(*) desc limit 1; 
Comments
Post a Comment