Important WebAssist Announcement

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › I want to sort by year, then month, then day. My columns in the db are integer.

Sign in to rate this thread

I want to sort by year, then month, then day. My columns in the db are integer.

Thread began 3/22/2022 10:56 am by jo271221 | Last modified 3/23/2022 10:40 am by Ray Borduin | 278 views | 2 replies |

3/22/2022 10:56 am | #1 jo271221

I want to sort by year, then month, then day. My columns in the db are integer.

More details in PM

Sign in to reply to this post

3/22/2022 2:10 pm | #2 Ray BorduinWebAssist

ORDER BY hh_year DESC, hh_month DESC, hh_day DESC

Sign in to reply to this post

Did this help? Tips are appreciated...

3/22/2022 6:52 pm | #3 jo271221

Awesome! Thank you!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Begin selling online quickly with Cafe Commerce.

Everything else!

►
Text Formatting
- Bold
- Italics
- Underline
- Highlight
- Color
- Size
- Font
►
Insert Element
- Image
- List
- Attachment
►
Insert Link
- Email
- URL
- To Post
- To Thread
►
Block Formatting
- Code
- Note
- Quote
- PHP
- HTML
- Indent
- Ignore Format
Cancel

Uploading file...