php - How to Set A Custom Load order For My User display Table based on Ranks -


so building new cms community , have run minor issue. want able list ranks highest in chain of command lowest, cannot work out how using string based ranks.

    <?php     include "dbh.php";     include "header.php";     $sql = "select * users_leo";     $result = $conn->query($sql);     $row = $result->fetch_assoc();     $rank = $row["rank"];     $department = $row["department"];        ?>     <div class="login-page">     </div>     <div class='form'>     <?php     $sql = "select * users_leo";     $result = $conn->query($sql);      if ($result->num_rows > 0) {     echo "<table>      <tr>         <th>in-game name</th>         <th>rank</th>         <th>department</th>         <th>profile</th>      </tr>";       while($row = $result->fetch_assoc()) {         echo "<tr>";         echo "<td>"; echo $row['username']; echo"</td>";         echo "<td>"; echo $row['username']; echo"</td>";         echo "<td>"; echo $row['department'];  echo"</td>";         echo '<td><a class="viewprofile" href="profile.php?id=' . $row['id']. '"><button>view profile</button></a></td>';         echo "</tr>";      } }     ?>    </div> </div>   </body>

as can see int below code, ranks stored strings

 echo "<select name='rank'> <option value='corrections officer'>corrections officer</option> <option value='senior corrections officer'>senior corrections officer</option> <option value='doc corporal'>doc corporal</option> <option value='doc sergeant'>doc sergeant</option> <option value='doc lieutenant'>doc lieutenant</option> <option value='doc head lieutenant'>doc head lieutenant</option> <option value='doc command'>doc command</option> <option value='trooper 3rd class'>trooper 3rd class</option> <option value='trooper 2nd class'>trooper 2nd class</option> <option value='trooper 1st class'>trooper 1st class</option> <option value='lance corporal'>lance corporal</option> <option value='state corporal'>state corporal</option> <option value='state sergeant'>state sergeant</option> <option value='first sergeant'>first sergeant</option> <option value='2nd lieutenant'>2nd lieutenant</option> <option value='1st lieutenant'>1st lieutenant</option> <option value='state command'>state command</option> <option value='officer'>officer</option> <option value='senior officer'>senior officer</option> <option value='police corporal'>police corporal</option> <option value='police sergeant'>police sergeant</option> <option value='staff sergeant'>staff sergeant</option> <option value='police lieutenant'>police lieutenant</option> <option value='police head lieutenant'>police head lieutenant</option> <option value='pd command'>pd command</option> <option value='overseer'>overseer</option>     </select>

i have tried , tried cannot find solution p.s. willing change ranks numbers if can explain how set displayed string.

if want select string in highest lowest order here code asc[ascending descending] , desc[descending ascending]

select * users_leo order column_name asc [or] desc;

-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more