sort by number about ci3-fire-starter HOT 1 CLOSED

You can't sort it without querying the database. I did not use a Javascript data grid that stores the entire record set. It only queries what is requested, and the keys must be the names of database columns within the users table. In your case, there is no column 'no'. I honesty don't see a need to sort by a number column since there's already a user id column that will sort asc/desc. Your number column is just showing the sequenced order of display. So I would just change your header so it isn't clickable to this:

<td>
    <?php echo $i; ?>
</td>

and in the 'else', change the colspan since you are adding another column:

<td colspan="8">

from ci3-fire-starter.