Advertisement
basart1

Untitled

Apr 14th, 2019
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1.  if(isset($_GET['id'])) {
  2.     $qr_result = mysql_query("SELECT * from `users` ORDER BY `id` ASC");
  3. }
  4.         elseif(isset($_GET['name1'])) {
  5.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `first_name` DESC");}
  6.         elseif(isset($_GET['surn'])) {
  7.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `surname` DESC");
  8.         }
  9.         elseif(isset($_GET['phone1'])) {
  10.             $qr_result = mysql_query("SELECT * from `users` ORDER BY `phone_number` DESC");
  11.         }  
  12.         while($data = mysql_fetch_array($qr_result))
  13.         {
  14.             echo '<tr>';
  15.             echo '<td>' . $data[`id`] . '</td>';
  16.             echo '<td>' . $data[`first_name`] . '</td>';
  17.             echo '<td>' . $data[`surname`] . '</td>';
  18.             echo '<td>' . $data[`phone_number`] . '</td>';
  19.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement