Ascending”SELECT * from name_of_table order BY date ASC”
Descending”SELECT * from name_of_table order BY date DESC”
Subscribe to feed
Tag Archives: Database
How to display the results from your database in order
18/02/2009 – 18:41
Retrieve Data From a MySQL Database
18/02/2009 – 18:35
Using PHP you can run a MySQL SELECT query to fetch the data out of the database.
Here is an example of one of the easiest ways to fetch data, this example uses a table called contact which has four columns, name, subject, address and message
<?php include ‘config.php’;?>
<?php
$query = “SELECT name, subject, address, message FROM [...]