Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Sql statement for group by order by

Sql statement for group by order by

Thread began 4/20/2021 7:17 am by jo271221 | Last modified 4/20/2021 3:15 pm by Ray Borduin | 13 views | 1 replies |

4/20/2021 7:17 am | #1 jo271221

Sql statement for group by order by

I would like to be able to group events together that are on the same day and also continue to date, state, city.
Also if an event spans multiple dates I would like them to display as below as well (Thursday to Sunday event example)

Current SQL ORDER BY eventdate, event_state, event_city ASC");

More info in PM

Thank you!

4/20/2021 3:15 pm | #2 Ray BorduinWebAssist

I had your FTP information from a previous support session, so I went in and fixed it for you.

You just need to keep track of the last shown date and not show it again if it has already been shown with a custom IF statement.

Did this help? Tips are appreciated...

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.