Search found 7 matches
- Thu Dec 22, 2005 10:47 pm
- Forum: Databases
- Topic: [resolved] Order by Date - Sorting Question
- Replies: 2
- Views: 546
worked like a charm
Thanks dude.... worked great
- Thu Dec 22, 2005 2:41 pm
- Forum: Databases
- Topic: [resolved] Order by Date - Sorting Question
- Replies: 2
- Views: 546
[resolved] Order by Date - Sorting Question
I have a question about ordering by date. If I order my query so that I'm displaying my dates in December 21, 2005 format, how can I sort by date order, and not alphabetically by the name of the month? If other words, when I do this Select * FROM table ORDER BY course_date I get this: 2005-12-20 200...
- Wed Dec 21, 2005 9:55 pm
- Forum: Databases
- Topic: Grouping Results - PHP or MySQL? Need Help!!
- Replies: 6
- Views: 1146
Solution Worked
You're solution worked great... thanks so much. I tweaked it slightly, as noted in the code section below: My next question however, is it possible (looping through the array) to display this information now into two main colums? I'd like to have it like so (I know my spacing is going to compress.. ...
- Wed Dec 21, 2005 10:55 am
- Forum: Databases
- Topic: Grouping Results - PHP or MySQL? Need Help!!
- Replies: 6
- Views: 1146
Thanks
Great.... I will work with this for awhile and see if I can get it working...
Thanks so much!
Christopher D. Rees
A+, Network+, Server+, MCSE, MCT
COPT Certified Law Enforcement Instructor
http://www.teamrees.com
Thanks so much!
Christopher D. Rees
A+, Network+, Server+, MCSE, MCT
COPT Certified Law Enforcement Instructor
http://www.teamrees.com
- Wed Dec 21, 2005 10:47 am
- Forum: Databases
- Topic: Grouping Results - PHP or MySQL? Need Help!!
- Replies: 6
- Views: 1146
Making Sense
[/quote]Then, when you're looping through the results, keep track of the last course_title. If the course_title in the current row isn't the same as the course_title in the last row, then you're at a new course - output the name of the course, then keep looping through the rows. I understand what yo...
- Wed Dec 21, 2005 9:38 am
- Forum: Databases
- Topic: Grouping Results - PHP or MySQL? Need Help!!
- Replies: 6
- Views: 1146
Grouping Results - PHP or MySQL? Need Help!!
Hello Everyone, I have a DB that I'm developing, that I've currently got functional, but I want to clean up the output. Currently, I have a site that displays currently available courses, listed by date. It shows the following: Course Date Course Title Notes =========================================...
- Wed Dec 21, 2005 9:37 am
- Forum: PHP - Code
- Topic: Grouping Results - Need Help!!
- Replies: 1
- Views: 207
Grouping Results - Need Help!!
Hello Everyone, I have a DB that I'm developing, that I've currently got functional, but I want to clean up the output. Currently, I have a site that displays currently available courses, listed by date. It shows the following: Course Date Course Title Notes =========================================...