If you want to select record from MySQL table using designing order, so first include database in you page, that’s like
<?php include "db_connect.php"; ?>
Now select data using select query and set ORDER BY field name and print all record in the page. select query store in the while loop and run and print all records in page.
For Example:
<?php $sql=mysqli_query($con,"SELECT * FROM signup ORDER BY id DESC"); while($row=mysqli_fetch_array($sql)){ print_r($row); } ?>
or
<?php $sql=mysqli_query($con,"SELECT * FROM signup ORDER BY name DESC"); while($row=mysqli_fetch_array($sql)){ print_r($row); } ?>
Question and answer is powered by AnsPress.io