PHP MySQL Order list

Solution:

Do not close the OL tag every time

OL = Ordered List

LI = List item

If you close and reopen the OL, it creates a new ordered list, and so restarting at 1.

<pre>

echo "&lt;ol&gt;";
foreach loop {
echo "&lt;li&gt;{$student_Value}&lt;/li&gt;";
}
echo "&lt;/ol&gt;";

</pre>
Copy code

Good luck.

Solution:

If you useMySQL to get the data you can addORDER BY to the query to order the result!

Here more info how to use ORDER BY

And change the HTML Code to be:

<ol>
    <li>$student_Value</li>
    <li>$student_Value</li>
    <li>$student_Value</li>
</ol>
Copy code

PHP Code will be:

echo "<ol>";
echo "   <li> $student_Value </li> ";//write all student values like this
//more student values
echo "</ol>";
Copy code

Solution:

It looks like your problem is more CSS related than PHP or SQL.

The reason is probably that your output is:

<ol><li>$student_Value</li></ol>
<ol><li>$student_Value</li></ol>
<ol><li>$student_Value</li></ol>
Copy code

Each student should be a list item within the ordered list:

<?php

print "<ol>";

while ($row = $result->fetch_assoc())
{
    print "<li>{$row['student']}</li>";
}

print "</ol>";

?>
Copy code

Solution:

You need something like that

<ol>
<?php
   for($i=0; $i<count($studentValue); $i++)
   {
?>
      <li><?php echo $studentValue[$i]; ?></li>
<?php 
   }
?>
<ol>
Copy code

I am giving you above example to tell you that under a 'ol' tag 'li' must be multiple to get your require result.