This query = Select everything from the database and put in order by year

The results input into a table without any manipulation

Reference NoDate TextLinkName
1 2001-01-01 Up to 250 characters here link Test 1
4 2001-02-02 No text link Test 4
2 2002-02-02 Up to 250 characters here link Test 2
5 2002-03-03 No text link Test 5
3 2003-03-03 Up to 250 characters here link Test 3
6 2003-04-04 No text link Test 6


This query = Select everything from the database and put in order by "reference number"
where the text colum data is "No text"

The results input into a table with the date format modified and only the results requred are displayed

DateTextName
02 February 2001 No text Test 4
03 March 2002 No text Test 5
04 April 2003 No text Test 6

Back to the main page