View Single Post
Old 11-26-2022, 08:33 PM  
sarettah
see you later, I'm gone
 
Industry Role:
Join Date: Oct 2002
Posts: 14,055
Quote:
Originally Posted by Publisher Bucks View Post
Is this possible to do?

I have a table that contains the following columns in it:

Month
Day
Year

The output on the page is:

December 15 2023
December 21 2023
December 02 2023

Is there a way that I can sort that data, if I'm pulling the date itself from 3 seperate columns using 3 echo statements?

Or, a better way to include the date in form input to put it into the sql table itself making it sortable?
Why do you have the dates split into month, day and year? And why 3 separate echo statements?

Anyway, you can concatenate the 3 columns together to make a sortable date.

Concat function: https://www.w3schools.com/sql/func_mysql_concat.asp


.
__________________
All cookies cleared!
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote