Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(isset($_GET['id'])) {
- $qr_result = mysql_query("SELECT * from `users` ORDER BY `id` ASC");
- }
- elseif(isset($_GET['name1'])) {
- $qr_result = mysql_query("SELECT * from `users` ORDER BY `first_name` DESC");}
- elseif(isset($_GET['surn'])) {
- $qr_result = mysql_query("SELECT * from `users` ORDER BY `surname` DESC");
- }
- elseif(isset($_GET['phone1'])) {
- $qr_result = mysql_query("SELECT * from `users` ORDER BY `phone_number` DESC");
- }
- while($data = mysql_fetch_array($qr_result))
- {
- echo '<tr>';
- echo '<td>' . $data[`id`] . '</td>';
- echo '<td>' . $data[`first_name`] . '</td>';
- echo '<td>' . $data[`surname`] . '</td>';
- echo '<td>' . $data[`phone_number`] . '</td>';
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement